Hello,
Quick question. I have a field that calculates no. of days before start of a workshop. This is the formula I'm using-
Hello,
Quick question. I have a field that calculates no. of days before start of a workshop. This is the formula I'm using-
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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.