Skip to main content

I've got an events calendar and an automation set up so that event registrants will get an email 6 hours prior to an event, using a formula field and the TONOW formula:

TONOW({Start})

The automation sends an email when the formula field reads "6 hours".

The trouble is, the field renders "6 hours" twice - once 6 hours before the event and again 6 hours after the event, so it triggers the automation to run again 6 hrs after the event.

Can anyone recommend a better formula to get what I'm looking for here?

Thanks!!!

Try using `DATETIME_DIFF()` instead? Formula field reference

 

Try using `DATETIME_DIFF()` instead? Formula field reference

 


Perfect! I used the following and it worked great: 

DATETIME_DIFF(Start,NOW(),'hours')

 Thanks for the help!

Reply


Terms & Conditions