I am using a date and time field that shows in ET- i.e 9/22/2023 11:00am. It was showing up in a weird way in automations, so i followed a formula that i saw in a pervious post to format it -
+10Hi Limi!
Th reason why you are seeing the time displayed in a different time zone has to do with how Airtable stores dates on their back end. All dates are in the UTC timezone, to rectify this you will need to add a function to first change the time zone of your date field to the appropriate time zone, and then switch the format.
This function is SET_TIMEZONE, which you can read about here.
In the end your formula should look something like this:
DATETIME_FORMAT(SET_TIMEZONE({Launch Date & Time},['timezone identifier']), 'M/D/YYYY \\at h:mma')
I hope this helps!
Chantal
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
