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

[alanair]

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?

[Sho · Accepted solution]

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.

 

[alanair]

 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!