Using time-based formulas to trigger automations

[Joel_Andrews1]

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!!!

[TheTimeSavingCo · Accepted solution]

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

 

[Joel_Andrews1]

Perfect! I used the following and it worked great: 

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

 Thanks for the help!