Sep 11, 2023 12:41 PM
Hello,
Quick question. I have a field that calculates no. of days before start of a workshop. This is the formula I'm using-
Solved! Go to Solution.
Sep 11, 2023 06:11 PM
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.
Sep 11, 2023 06:11 PM
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.
Sep 14, 2023 09:40 AM
Thank you so much!