I am looking at a google sheet which includes a date column, I am trying to filter, based on either search rows or a make routing filter, on the current date + 7 days. However other than the now parameter I cannot seem to find a way to either express the current date, or that date plus or minus a number of days, I tried using now and the add days function but that only seems to work for a specified date and I need this variable, depending on when the scenario is run.
The date format is dd-mm-yyyy am I missing something super obvious here, or does make not support date comparisons in this fashion?
Kind Regards,
Alan
1. If you have a new question in the future, please start a new thread. This makes it easier for others with the same problem to search for the answers to specific questions, and you are more likely to receive help since newer questions are monitored closely.
2. The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep the Community organized.
This marks the topic as solved, so that
others can save time when catching up with the latest activity here, and
allows others to quickly jump to the solution if they come across the same problem
To do this, simply click the checkbox at the bottom of the post that answers your question:
3. Don’t forget to like and bookmark this topic so you can get back to it easily in future!
