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?
Solved
Show current time NOW() in 'America/Los_Angeles'
+3Best answer by Sho
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.
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.
+3I could have sworn that the formatting option wasn't available when it was a formula field... but it is and that worked. thank you!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.