How to track dates 14 days and older and 30 days and older in Google Sheets

You can use the built-in function parseDate to convert the date-like strings into date variables first, before comparing it to (now - 14) days

e.g.:

{{ parseDate(1.date; "date format goes here") > addDays(now; -14) }}

For more information, see the function documentation in the Help Center.

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 —

General

Help Center Basics

Articles & Videos

samliewrequest private consultation

Join the unofficial Make Discord server to chat with other makers!

2 Likes