# Update Google Sheet row based on today's date **URL:** \ **Category:** Questions\ **Tags:** filters\ **Created:** [March 30, 2025, 2:49am UTC](https://community.make.com/t/update-google-sheet-row-based-on-todays-date/76969 "2025-03-30T02:49:52Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![douglasAI](https://avatars.discourse-cdn.com/v4/letter/d/7feea3/32.png) [@douglasAI](https://community.make.com/u/douglasAI)\ **Post date:** [March 30, 2025, 2:49am UTC](https://community.make.com/t/update-google-sheet-row-based-on-todays-date/76969/1 "2025-03-30T02:49:52Z")
Hi all, I’m trying to update a Google Sheet based on today’s date, but can’t seem to get it to work. Here’s the screenshot of the “Search Rows” module. The “Text Operator: Equal to” doesn’t appear to be working. ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/4/b/4b9a56895660e0c0b71157ea7ae10819db992a24.png) Here’s how my Gsheet is set up: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/5/65156071b718490cd7af6d51da99ce70f39ac8b1.png) Appreciate any help! ---
**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:** [March 30, 2025, 3:27am UTC](https://community.make.com/t/update-google-sheet-row-based-on-todays-date/76969/2 "2025-03-30T03:27:57Z")
Welcome to the Make community! Looks like you have a stray space before the format — ` MM` ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/e/6/e63787c204696b07f870fd76f6b89a6897aefc44.png) Delete any space otherwise the “Equal to” will not match! Hope this helps! Let me know if there are any further questions or issues. — @samliew P.S.: Investing some effort into the [Make Academy](https://academy.make.com) will save you lots of time and frustration using Make. ---
**Author:** ![douglasAI](https://avatars.discourse-cdn.com/v4/letter/d/7feea3/32.png) [@douglasAI](https://community.make.com/u/douglasAI)\ **Post date:** [March 30, 2025, 1:59pm UTC](https://community.make.com/t/update-google-sheet-row-based-on-todays-date/76969/3 "2025-03-30T13:59:35Z")
Thanks for the quick reply! I removed the space, but am still not getting any outputs. ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/7/57fa5dca52b8e13fc20564020287041e43183592.png) ---
**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:** [March 31, 2025, 3:09am UTC](https://community.make.com/t/update-google-sheet-row-based-on-todays-date/76969/4 "2025-03-31T03:09:52Z")
Your format is incorrect. You are using the DD and MM tokens, which produces a leading ZERO, so it is formatting your date into the following: e.g.: ```plaintext 04/01/2025 12/01/2025 12/31/2025 etc... ``` As you can see, your spreadsheet dates are NOT in this format `MM/DD/YYYY`. Please refer to the [Tokens](https://www.make.com/en/help/functions/tokens-for-date-time-formatting) you can use to format a date variable. You should be using `M/D/YYYY` instead. e.g.: ```plaintext {{ formatDate(now; "M/D/YYYY") }} ``` For more information, see Date Format links below. Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too — ### Getting Started - [Help Centre](https://www.make.com/en/help) | [Tutorials](https://www.make.com/en/help/tutorials.html) – Make “Manual” - [Make Academy](https://academy.make.com) – Basics 101: Learn Make and get certified ### Help Centre Basics - [Mapping](https://www.make.com/en/help/mapping/mapping) – What is mapping? What can I map? - [Mapping with arrays](https://www.make.com/en/help/mapping/mapping-arrays) – How to map items in an array - [Aggregate an array for mapping complex fields](https://www.make.com/en/help/tools/flow-control#customizing-the-output) - **Date Format** : [tokens for `parseDate`](https://www.make.com/en/help/functions/tokens-for-date-time-parsing) | [tokens for `formatDate`](https://www.make.com/en/help/functions/tokens-for-date-time-formatting) - [HTTP modules](https://www.make.com/en/help/tools/http) – Make a request, Get (download) a file - [Webhooks](https://www.make.com/en/help/tools/webhooks) – Error Handling, Responding to webhooks ### Articles & Videos - [Router Magic Formula](https://www.youtube.com/watch?v=4Q-5BsCtJu4) - YouTube - [Error Handlers in Make](https://www.youtube.com/playlist?list=PLRE9E-rAD8U10mx2TRs54Nq1XJDdK9Kx4) - YouTube playlist - [Getting started with OpenAI](https://community.make.com/t/getting-started-with-openai-gpt-3-and-make/7796) - How to setup and use OpenAI (ChatGPT) in Make - [How to use Regex in Make](https://community.make.com/t/how-to-use-regex-in-make/202) - How to use pattern matching to extract the text you want - [Webhooks – Make Academy](https://academy.make.com/courses/IntermediateC04) – tutorial on how to use Webhooks Hope this helps! Let me know if there are any further questions or issues. — @samliew P.S.: Investing some effort into the [Make Academy](https://academy.make.com) will save you lots of time and frustration using Make. ---
**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:** [June 29, 2025, 3:12am UTC](https://community.make.com/t/update-google-sheet-row-based-on-todays-date/76969/5 "2025-06-29T03:12:30Z")