Help

Re: Time to Formula Help

Solved
Jump to Solution
492 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Joel_Andrews1
7 - App Architect
7 - App Architect

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

1 Solution

Accepted Solutions
TheTimeSavingCo
17 - Neptune
17 - Neptune
2 Replies 2
TheTimeSavingCo
17 - Neptune
17 - Neptune

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

Screenshot 2023-04-25 at 2.15.10 PM.png

Perfect! I used the following and it worked great: 

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

 Thanks for the help!