Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Time from DATE_FORMAT() is incorrect

Topic Labels: Dates & Timezones
Solved
Jump to Solution
267 2
cancel
Showing results for 
Search instead for 
Did you mean: 

I’m have some datetime fields that I’m trying to format down to isolate the time. However, I’m seeing that there are some glitches with how the time renders based on time zone. My source datetime field is formatted to PDT, but the output appears to be GMT. I don’t see a way to correct this because switching the datetime field to GMT for all collaborators produces bogus times that cannot be used for local dates. Is there an operator to add in the formula that corrects the glitch from the source datetime field, or is there a way to “lock-in” the time in the base so that GMT doesn’t muck things up?

Airtable_Formula_Datetime_00

Airtable_Formula_Datetime_01

Airtable_Formula_Datetime_02

1 Solution

Accepted Solutions

You need to use SET_TIMEZONE().It is documented in the Formula Field Reference.

DATETIME_FORMAT(
    SET_TIMEZONE({Session 00 Start Time}, 'America/Los_Angeles'),
    'LT'
)

See Solution in Thread

2 Replies 2

You need to use SET_TIMEZONE().It is documented in the Formula Field Reference.

DATETIME_FORMAT(
    SET_TIMEZONE({Session 00 Start Time}, 'America/Los_Angeles'),
    'LT'
)