Sending an Automated Message at an Exact Time

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