Trigger Email After 7 Days Contact

[Gavin_C]

Hi Airtable Community!

I want to be able to send an email if 7 days has passed since they last received an email.

I have set a date field in my database to be populated with today's date when an email is sent from my automations.

I now want to create another field that includes a "1" if today's date is greater than 7 days, or "0" if not.

I can then trigger future emails if a "1" is present in the field.

I'm nearly there with this formula (see attached).

IF(TODAY()-{Last Contact Date}>7,"1","0")

Does anyone know what I'm missing please?

Thanks,

Gavin

[Ron_Williams · Accepted solution]

This should work:

IF(DATETIME_DIFF(TODAY(),{Last Contact Date},'days')>7,"1","0")

[Gavin_C]

Hi Ron,

It definitely did work, much appreciated. You're a star - thank you.

Best,

Gavin

[Gavin_C]

Hey there,

I'm struggling the with date format and was hoping someone might be able to help?

I have set up a field that pulls in today's date (thanks to @Ron_Williams) - see here. When an email is sent I have an automation that pulls that field into another field called 'Last Contact Date' - see here

The problem is I'm getting strange dates in the 'Last Contact Date' field even though I have set the field date format the same DD/M-/YYYY - see here 

Does any know why and how to fix it?

Thanks,
Gavin

[Gavin_C]

I've just noticed this error message, which I thought might help diagnose the issue.

 

[Ron_Williams]

If you use TODAY() in the Last Contact Date field it should work. You may need to change the formatting in the formatting tab of the field to make it look the way you want. 

[Gavin_C]

Thanks again Ron, you cracked it.