I have a date field called 'StartDate' which is displays in the data as
2/8/2017 12:00
.
I want to create a list that displays the dates (StartDate) however, within the data it is possible for the same actual date to appear twice. For example
StartDate
2/8/2017 15:15
2/8/2017 12:00
2/8/2017 17:47
In my script, I have transformed the date to only pull in the left 10 characters of the field by doing
LEFT(StartDate, 10) as cmpSTRTDTE so that when I create a list box, the data appears as 2/8/2017. However, there are still multiple values for 2/8/2017.
Is there a way to either in the script or in a calculated dimension only display the date once?
Ideally, I want the list to display the StartDates but only have each date appear once.
