Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Sending an Automated Message at an Exact Time

Topic Labels: Automations
161 0
cancel
Showing results for 
Search instead for 
Did you mean: 

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