DATETIME_FORMAT and SET_TIMEZONE for NOW()

[Ilyia_Davis]

Hi :slightly_smiling_face:
Does anyone know what supported timezones for SET_TIMEZONE for Mountain Time (US)?

Thanks!

[Raminder_Singh]

See if one of the locations in this list are in Mountain Time (US).

[Ilyia_Davis]

Thanks @Raminder_Singh
I have tried to find a Mountain Time location in that list but haven’t had any luck. I must be missing it and that is my question, which of those list times is for Mountain Time?

[Raminder_Singh · Accepted solution]

Sorry @Ilyia_Davis I don’t have a good knowledge of US geography as I don’t live there but America/Boise might work. I am basing it on this Wikipedia page. Please confirm with other sources before you use this in your formula.

Hope this helps :slightly_smiling_face: