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.

Attempts to Correct Timezone Ineffective

Topic Labels: Formulas
Solved
Jump to Solution
350 2
cancel
Showing results for 
Search instead for 
Did you mean: 

I’m having trouble getting DATETIME_FORMAT to work, and I can’t figure out what I’m missing.

My date field is in local time. I wanted to get week numbers from the date, which I have working fine, but it is seeing dates in UTC I think, and DATETIME_FORMAT did not work.

Formula: DATETIME_FORMAT(SET_TIMEZONE(Date,'America/Los Angeles'),'MM/DD/YYYY')

AT DateTime Error

Referencing the red box you can see two entries with incorrect format. I’m a little stumped.

1 Solution

Accepted Solutions

You misspelled the timezone indicator. It should be Los_Angeles (with an underscore), not Los Angeles (with a space).

See Solution in Thread

2 Replies 2

You misspelled the timezone indicator. It should be Los_Angeles (with an underscore), not Los Angeles (with a space).

Aha! I knew it was something simple. Thanks for the help.