Help

The Community will be undergoing maintenance on Friday January 10 at 2:00pm - Saturday January 11 at 2:00pm EST, and will be "read-only." For assistance during this time, please visit our Help Center.

DATETIME_PARSE() not respecting timezone

Topic Labels: Formulas
Solved
Jump to Solution
949 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Cody_Winchester
6 - Interface Innovator
6 - Interface Innovator

After through the documentation on DATETIME_PARSE() I’m not seeing the timezone respected when used in conjunction with either SET_LOCALE() or SET_TIMEZONE() for conversion of a string field containing date and time information. What am I missing here:

Airtable_Timezone Glitch_00

1 Solution

Accepted Solutions
Cody_Winchester
6 - Interface Innovator
6 - Interface Innovator

Nevermind. Removing the input format and locale options returns the correct information:

DATETIME_PARSE({Completed At (PST/PDT)})

See Solution in Thread

1 Reply 1
Cody_Winchester
6 - Interface Innovator
6 - Interface Innovator

Nevermind. Removing the input format and locale options returns the correct information:

DATETIME_PARSE({Completed At (PST/PDT)})