I have a fairly simple automation, that takes data from a CSV and add it to a google sheets sheet.
I want to filter the rows by date, so it only adds records, where the data is more than 7 days ago. I am using a router to filter.
The date format in the data is: June 14, 2024
So this is what I have setup in the filter:
Condition: {{parseDate(7.array[].col17; “”“MMMM DD, YYYY”“”)}}
Datetime operators: Earlier than addDays(now;-2)
I am not really sure what to write in the 2nd field. It’s not working now. Any ideas?