Send e-mail when date is today

[Mark_van_Hussen]

Hi!

I have spent many hours last week but I can’t get this to work:

• Based on dates in a Google Sheets
• I want to send out an e-mail when the day matches to today

The scenario

The output

The filter

The filter will not will not match with date.

For testing purpose I have set the filter to -3 since today is October 7, and date from the Google sheet is October 4.

Thanks!

Mark

[Henk-Operative]

Hi @Mark_van_Hussen ,

Consider that the result of your operation resolves to a ISO8601 date format and not just the DD-MM-YYYY you are trying to match:

So using a formatDate() function might help!

Cheers,
Henk

[Mark_van_Hussen]

Thanks @Henk-Operative !