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