Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Date Formatting

351 1
Showing results for 
Search instead for 
Did you mean: 

Having an issue with Date formatting which seemed simple. Here is my issue. My primary key shows the correct EST time as the published date. I am trying to use for a gallery and used a field called Date Formatted with the following command. It works great but is off by 5 hours which I assume is GMT time. How do I format this primary key to take into consideration the GMT difference?

DATETIME_FORMAT({Date Published}, ‘MM-DD-YYYY hh:mm’)

1 Reply 1

You can use a formula like this to set the time zone:

DATETIME_FORMAT(SET_TIMEZONE({Date Published}, 'Europe/London'),'MM-DD-YYYY hh:mm')

A list of supported time zones is here:

Also, for a real deep dive into Airtable time zones, you can check out my training video & sample base here: