Skip to main content
Solved

Formula to calculate no. of days after training completion

  • September 11, 2023
  • 2 replies
  • 47 views
A
Forum|alt.badge.img+3

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 🙂

Best answer by Sho

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.

2 replies

S
Forum|alt.badge.img+21
  • Sho
  • Inspiring
  • Answer
  • September 12, 2023

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.

A
A
Forum|alt.badge.img+3
  • amykalra
  • Author
  • Participating Frequently
  • September 14, 2023

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!

Terms & ConditionsAccessibility statement