Gmail automation triggered a day earlier

[Nedra_Hines]

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?

[kuovonne · Accepted solution]

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.

[Nedra_Hines]

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