Help

Show current time NOW() in 'America/Los_Angeles'

Topic Labels: Dates & Timezones Formulas
Solved
Jump to Solution
2131 2
cancel
Showing results for 
Search instead for 
Did you mean: 
alanair
4 - Data Explorer
4 - Data Explorer
I'm using formula:
SET_TIMEZONE(NOW(),'America/Los_Angeles')
 
I want it to show the current time in LA but it keeps returning the UTC time instead.
 
Any idea what's wrong with the formula?
1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

 

Check the formatting settings, if "Use the same time zone for all collaborators" is enabled, the SET_TIMEZONE function will be disabled and this setting will take effect.2023-09-29 090045.png

See Solution in Thread

2 Replies 2
Sho
11 - Venus
11 - Venus

 

Check the formatting settings, if "Use the same time zone for all collaborators" is enabled, the SET_TIMEZONE function will be disabled and this setting will take effect.2023-09-29 090045.png

alanair
4 - Data Explorer
4 - Data Explorer

 I could have sworn that the formatting option wasn't available when it was a formula field... but it is and that worked. thank you!