Get a Date from google sheets and do an automation if that date is a week old

Hi there,

So I want to send an email a week after a user has signed up to my application. The current flow is that i enter the users details into a google sheet which has a date in the format of YYYY-MM-DD, and then the make scenario uses a filter to add days to the date and compare it with the current date. But for some reason when i run the scenario it wont work. i am not getting any errors and it just stops right at the filter. The application works properly when i dont have the filter on so its something to do with the way i am using the filter.

Is there something i am doing wrong with my filter? thanks



some more images


Welcome to the Make community!

By using the addDays function, you are converting the string containing a date into a date type variable.

You still need another formatDate function to format it into the same string format you are using in the second half of the condition.

e.g.:

formatDate(addDays( ...

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.

That worked, thanks for the help.

This is the finished function for reference for anyone else who needs this done. This function gets the date variable from the google sheet and adds 7 days to it and compares it to the current date. If the dates equal then it means uts been a week and the automation continues.