Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Time to Formula Help

Topic Labels: Automations Formulas
Solved
Jump to Solution
1293 2
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
18 - Pluto
18 - Pluto

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

Screenshot 2023-04-25 at 2.15.10 PM.png

 

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

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!