Skip to main content

Hello,

 

Quick question. I have a field that calculates no. of days before start of a workshop. This is the formula I'm using- 

DATETIME_DIFF({Start Date/Time}, NOW(),'days').
 
I now want to create a field that calculates number of days 'after' a workshop. I want to use this for an automation. So for eg: if days after training completion =7, send email. What formula can I use here? I tried using a dateadd formula but I'm getting it wrong.
 
Thank you 🙂

This formula will output 1 after 7 days of the date.
How about triggering an automation that sends an email when it reaches 1?

IF(DATETIME_DIFF(DATEADD({Date},7,'Days'), TODAY(),'days')=0,1)

Now() includes time, so there may be time differences. Today() is date only.


This formula will output 1 after 7 days of the date.
How about triggering an automation that sends an email when it reaches 1?

IF(DATETIME_DIFF(DATEADD({Date},7,'Days'), TODAY(),'days')=0,1)

Now() includes time, so there may be time differences. Today() is date only.


Thank you so much!


Reply