Help

Sending an Automated Message at an Exact Time

Topic Labels: Automations
539 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Daniel_m
4 - Data Explorer
4 - Data Explorer

Hi AT Community,

I’m trying to use an automation to send a happy birthday message on an exact day at a precise time (Los Angeles timezone). For Johnny Test the send date field indicates 7AM LA time but this message was actually sent at 7:50 AM Chicago time (which is where I’m located) which is too early.

Screen Shot 2022-09-04 at 9.20.30 AM

image

image

Here’s the formula I’m using (from this post: Using When Record Matches Conditions For A Specific Date & Time

IF(
   DATETIME_FORMAT(SET_TIMEZONE({Send Date}, 'America/Los_Angeles'), 'X') <= 
   DATETIME_FORMAT(SET_TIMEZONE(NOW(), 'America/Los_Angeles'), 'X'), 
   "✔️"
)```

Thanks for any tips that you all might be able to provide! 

Daniel
0 Replies 0