Help

Formula to calculate no. of days after training completion

Topic Labels: Formulas
Solved
Jump to Solution
467 2
cancel
Showing results for 
Search instead for 
Did you mean: 
amykalra
5 - Automation Enthusiast
5 - Automation Enthusiast

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

Accepted Solutions
Sho
11 - Venus
11 - Venus

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.

See Solution in Thread

2 Replies 2
Sho
11 - Venus
11 - Venus

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.

amykalra
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you so much!