Date Formatting

[Charles_Osterta]

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’)

[ScottWorld]

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:

Airtable Support

Supported timezones for SET_TIMEZONE

The SET_TIMEZONE function will allow you to set the timezone for the data from a date type field. This is written in the form "SET_TIMEZONE(datetime, 'timezone identifier')," in which the...

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

Airtable

Time Zones: Working with multiple different time zones in Airtable - Airtable...

This Airtable base solves the problem of events taking place in different time zones, and users wanting to know what time those events are taking place in...