Help

Re: Date Formatting

267 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Charles_Osterta
6 - Interface Innovator
6 - Interface Innovator

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 pory.io 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: