I'm trying to get the last 30 days of data for an imported csv, but the system tells me that my dateformats are incompatible. However, i can's see any real reason why or workaround, so any advice is welcome.
My process is as follows :
-> read csv, date is imported as nominal and is formatted as 'YYYY-MM-DD HH:mm:ss'
-> Nominal to date, date type = date_time, this gives me my date (entryTime) in following format on screen: Jan 7, 2017, 4:15:33 AM CET, but when I copy it it looks like this : Sat Jan 07 16:15:33 CET 2017
-> Next I create a macro called startdate, using following function : date_add(date_now(),-30,DATE_UNIT_DAY), which results in something like Jun 30, 2017 7:13:46 PM CEST
-> next I create a filter stating that my datefield needs to be bigger or equal than %{startdate} but it gives me an error stating :
'cannot instantiate custom filters: the filter value 'Jun 30, 7:20:30 PM CEST for the attribute entryTime is not in a valid format. Formatting example: 12/31/2014 3:00:00 PM.
So I assume I need to change my dateformat somehow, but if I use date to nominal in the MM/dd/yyyy format and then back nominal to date I get the same problem. So what do I need to do, or are there other ways to filter dateranges?
