# Send e-mail when date is today

**URL:** https://community.make.com/t/send-e-mail-when-date-is-today/57237
**Category:** Questions
**Tags:** filters
**Created:** [October 7, 2024, 3:35pm UTC](https://community.make.com/t/send-e-mail-when-date-is-today/57237 "2024-10-07T15:35:41Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Mark\_van\_Hussen](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/mark_van_hussen/32/47788_2.png) [@Mark\_van\_Hussen](https://community.make.com/u/Mark_van_Hussen)
#### Post date: [October 7, 2024, 3:35pm UTC](https://community.make.com/t/send-e-mail-when-date-is-today/57237/1 "2024-10-07T15:35:41Z")

</div>

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

 ![Screenshot 2024-10-07 at 17.30.47](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/d/6d43a64fa30802b330d6c4ecbcad4b1b8e85c501.png)

The output

 ![Screenshot 2024-10-07 at 17.29.24](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/7/0/70de09da8c1b5c329857f23b6d0e42b2b1b64dc8.png)

The filter

 ![Screenshot 2024-10-07 at 17.29.43](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/9/1/919d969825b427c8298323650c924610ae579f02.png)

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

---

<div class="post-metadata">

### Author: ![Henk-Blue\_Marker](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/henk-blue_marker/32/89127_2.png) [@Henk-Blue\_Marker](https://community.make.com/u/Henk-Blue_Marker)
#### Post date: [October 7, 2024, 4:04pm UTC](https://community.make.com/t/send-e-mail-when-date-is-today/57237/2 "2024-10-07T16:04:38Z")

</div>

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: ![Scherm­afbeelding 2024-10-07 om 18.02.34](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/5/856a340ae0cb7300265a08e23e1d76e5c7321d9f.png)

So using a formatDate() function might help!

Cheers,  
Henk

---

<div class="post-metadata">

### Author: ![Mark\_van\_Hussen](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/mark_van_hussen/32/47788_2.png) [@Mark\_van\_Hussen](https://community.make.com/u/Mark_van_Hussen)
#### Post date: [October 7, 2024, 5:31pm UTC](https://community.make.com/t/send-e-mail-when-date-is-today/57237/3 "2024-10-07T17:31:38Z")

</div>

Thanks @Henk-Blue_Marker !

---

<div class="post-metadata">

### 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: [October 21, 2024, 8:23pm UTC](https://community.make.com/t/send-e-mail-when-date-is-today/57237/4 "2024-10-21T20:23:31Z")

</div>