I have a column "creationdate" which has the format
YYYY-MM-DD HH:MM.MS for example: 2015-07-01 23:59.999
After loading this column with "Date(creationdate, 'DD.MM.YYYY' )AS creationdate", i only have the date without the time.
Now i have a new problem: the same dates in this column are shown as distinct values. I can't use this column as a filter option, because i would have to choose the same date as often as it appears in my data.
I guess they are shown as distinct values, because the different times behind the dates make the values technically different. Is my guess right?
