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.

Automation when DATE is Today - Change Time

1012 3
cancel
Showing results for 
Search instead for 
Did you mean: 
sam-lsf-lst
5 - Automation Enthusiast
5 - Automation Enthusiast

I have a "Send an email" automation set up with the trigger "when {{Date field}} is one week from now."

It's working great, except the emails are going out just after midnight. I'd prefer them to go around 9am. I have added a time to my date field, but that does not seem to work. 

Any advice? 

 

samlsflst_0-1715950957399.png

samlsflst_1-1715950974691.png

 

 

3 Replies 3
Dan_Montoya
Community Manager
Community Manager

I would add a field that is datetime_diff(duedate, now(), 'hours'), then when your hours_till_due  = 168 (hours) send your email.  Then you can send it out at 9AM.  If you change that due time to noon, it would send those out at noon.

sam-lsf-lst
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks Dan! I thought something like this would work, was just hoping there was a native option using the time within the date field. But this workaround will do! 

Dan_Montoya
Community Manager
Community Manager

Since I first responded I learned about IS_after formula.   See if that works for you.