Filter data by data

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?



Welcome to the Make community!

Remove the two double quotes from the date format. It is preventing the format from matching the date.

Hope this helps! Let me know if there are any further questions or issues.

@samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

Thanks. I still cannot get it to work. It still fetches all rows.

This is how it looks now:

I think it is the parseDate where the error is, since it doesn’t change anything if I set the Earlier than date manually.

The filter has to be moved to before the array aggregator.

1 Like

Thanks a lot. I set the filter after the CSV parser instead and it works now.

I don’t understand why it works when the other one didn’t?

Isn’t is possible to filter from an array?