Skip to main content

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
Be the first to reply!

Reply