+2Hi all,
I have set up a gmail automation and am sending an ISO Date time to the email recipient. The date time that is sent is 4 hours ahead of what is entered in my table. Any ideas as to why this is happening?
In the screenshot of the table view, I do not have a time zone set for date_ordered. I tried with the proper timezone configured as well and it still has the same issue.
Best answer by AirOps
Hi @primeBias84,
Welcome to the joys of working with time zones in Airtable - it can get a little messy if you don't know exactly how timezones are handled.
In this case when you pull any field type of "Date" into an email automation the result will be an ISO formatted string in the GMT/UTC timezone irregardless of the actual timezone settings you have set in the field.
To get around this you will want to format your date into a string for use in the email automation. You will likely need to use a combination of the DATETIME_FORMAT() function and the SET_TIMEZONE() Function.
Your formula should look something like this:
Supported format specifiers for DATETIME_FORMAT
Supported timezones for SET_TIMEZONE
I hope this helps!
+10Hi @primeBias84,
Welcome to the joys of working with time zones in Airtable - it can get a little messy if you don't know exactly how timezones are handled.
In this case when you pull any field type of "Date" into an email automation the result will be an ISO formatted string in the GMT/UTC timezone irregardless of the actual timezone settings you have set in the field.
To get around this you will want to format your date into a string for use in the email automation. You will likely need to use a combination of the DATETIME_FORMAT() function and the SET_TIMEZONE() Function.
Your formula should look something like this:
Supported format specifiers for DATETIME_FORMAT
Supported timezones for SET_TIMEZONE
I hope this helps!
+35As @AirOps mentioned above, time zones are quite the challenge in Airtable.
In addition to Cherry’s advice above, you may also want to check out my time zone base & time zone training video here:
+2Hi @primeBias84,
Welcome to the joys of working with time zones in Airtable - it can get a little messy if you don't know exactly how timezones are handled.
In this case when you pull any field type of "Date" into an email automation the result will be an ISO formatted string in the GMT/UTC timezone irregardless of the actual timezone settings you have set in the field.
To get around this you will want to format your date into a string for use in the email automation. You will likely need to use a combination of the DATETIME_FORMAT() function and the SET_TIMEZONE() Function.
Your formula should look something like this:
Supported format specifiers for DATETIME_FORMAT
Supported timezones for SET_TIMEZONE
I hope this helps!
Thank you, this worked!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.