Update Google Sheet row based on today's date

How To
4

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 —

Getting Started

Help Centre Basics

Articles & Videos

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.