Filter data by data

How To
,
1

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?

2

Screenshot_15
Screenshot_151842×409 48.6 KB

Screenshot_18
Screenshot_18908×812 51.5 KB

Screenshot_20
Screenshot_20743×664 33.3 KB

3

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.

4

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

This is how it looks now:

Screenshot_21
Screenshot_21970×694 48.6 KB

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

5

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

1 Like
6

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

Screenshot_23
Screenshot_232353×545 95.2 KB

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

Isn’t is possible to filter from an array?