+10Happy 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?
Best answer by kuovonne
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.
+29Airtable 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.
+10Airtable 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.