# Date time parameters to check google sheets vs current time **URL:** \ **Category:** Questions\ **Tags:** google-sheets, filters, mapping\ **Created:** [February 27, 2024, 9:21am UTC](https://community.make.com/t/date-time-parameters-to-check-google-sheets-vs-current-time/28778 "2024-02-27T09:21:27Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Alan\_Keatinge](https://avatars.discourse-cdn.com/v4/letter/a/e274bd/32.png) [@Alan\_Keatinge](https://community.make.com/u/Alan_Keatinge)\ **Post date:** [February 27, 2024, 9:21am UTC](https://community.make.com/t/date-time-parameters-to-check-google-sheets-vs-current-time/28778/1 "2024-02-27T09:21:27Z")
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 ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [February 27, 2024, 10:31am UTC](https://community.make.com/t/date-time-parameters-to-check-google-sheets-vs-current-time/28778/2 "2024-02-27T10:31:10Z")
Welcome to the Make community! According to the [Tokens](https://www.make.com/en/help/functions/tokens-for-date-time-formatting) you can use to format a date variable, you can use `DD-MM-YYYY`. e.g.: `{{formatDate(addDays(now; 7); "DD-MM-YYYY")}}` ---
**Author:** ![Alan\_Keatinge](https://avatars.discourse-cdn.com/v4/letter/a/e274bd/32.png) [@Alan\_Keatinge](https://community.make.com/u/Alan_Keatinge)\ **Post date:** [February 27, 2024, 1:11pm UTC](https://community.make.com/t/date-time-parameters-to-check-google-sheets-vs-current-time/28778/3 "2024-02-27T13:11:02Z")
Thank you! that worked an absolute charm, delighted, been banging my head off this half the day. ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [February 27, 2024, 1:44pm UTC](https://community.make.com/t/date-time-parameters-to-check-google-sheets-vs-current-time/28778/4 "2024-02-27T13:44:13Z")
No problem, glad I could help! 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](https://community.make.com/t/make-community-the-ultimate-topic/11682) 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: ![](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/d/5d9b26fbef0fd7385a34084f61cd5b9165786f42.png) 3. Don’t forget to like and bookmark this topic so you can get back to it easily in future! ---
**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\ **Post date:** [March 12, 2024, 1:18pm UTC](https://community.make.com/t/date-time-parameters-to-check-google-sheets-vs-current-time/28778/5 "2024-03-12T13:18:11Z")