Skip to main content

Automation when DATE is Today - Change Time

  • May 17, 2024
  • 3 replies
  • 36 views

Forum|alt.badge.img+7

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? 

 

 

 

3 replies

Dan_Montoya
Forum|alt.badge.img+17
  • Employee
  • 275 replies
  • May 17, 2024

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.


Forum|alt.badge.img+7
  • Author
  • Participating Frequently
  • 9 replies
  • June 7, 2024

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.


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
Forum|alt.badge.img+17
  • Employee
  • 275 replies
  • June 7, 2024

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