Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

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

Topic Labels: Dates & Timezones Formulas
Solved
Jump to Solution
2686 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!