Help

Gmail automation triggered a day earlier

Topic Labels: Dates & Timezones
Solved
Jump to Solution
259 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Nedra_Hines
6 - Interface Innovator
6 - Interface Innovator

Happy Holidays everyone! I have a table that includes columns for both Start Date and End Date. Date format for both date fields is "Local". My gmail automation is setup so that when 'today' is 10 days from the End Date, the client will receive an automated email.

This example, the End date is January 6, 2024 and the email automation triggered December 26th, which is 11 days from the End Date.

How can I fix this so that it triggers when 'today' is 10 days from the End date?

 

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

Airtable tends to use GMT time under the hood, even when the display format is "Local".

A quick-and-dirty workaround is to adjust your automation to use 9 days instead of 10 days.

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

Airtable tends to use GMT time under the hood, even when the display format is "Local".

A quick-and-dirty workaround is to adjust your automation to use 9 days instead of 10 days.

Thank you! Yes, I adjusted the automation to 9 days.