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.
Here’s how my Gsheet is set up:
Appreciate any help!
Welcome to the Make community!
Looks like you have a stray space before the format — MM
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 will save you lots of time and frustration using Make.
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.:
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 you can use to format a date variable. You should be using M/D/YYYY instead.
e.g.:
{{ 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 —
parseDate | tokens for formatDateHope 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.