Help

Trigger Email After 7 Days Contact

Solved
Jump to Solution
769 6
cancel
Showing results for 
Search instead for 
Did you mean: 
Gavin_C
4 - Data Explorer
4 - Data Explorer

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
1 Solution

Accepted Solutions
Ron_Williams
6 - Interface Innovator
6 - Interface Innovator

This should work:

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

See Solution in Thread

6 Replies 6
Ron_Williams
6 - Interface Innovator
6 - Interface Innovator

This should work:

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

Hi Ron,

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

Best,

Gavin

Gavin_C
4 - Data Explorer
4 - Data Explorer

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

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

Screenshot 2023-08-14 at 16.57.46.png

Ron_Williams
6 - Interface Innovator
6 - Interface Innovator

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. 

Thanks again Ron, you cracked it.