Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Time from DATE_FORMAT() is incorrect

Topic Labels: Dates & Timezones
Solved
Jump to Solution
1033 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Cody_Winchester
6 - Interface Innovator
6 - Interface Innovator

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
kuovonne
18 - Pluto
18 - Pluto

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
kuovonne
18 - Pluto
18 - Pluto

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

Exquisite! Thanks @kuovonne!