Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 09, 2022 11:42 AM
I’m have some datetime fields that I’m trying to format down to isolate the time. However, I’m seeing that there are some glitches with how the time renders based on time zone. My source datetime field is formatted to PDT, but the output appears to be GMT. I don’t see a way to correct this because switching the datetime field to GMT for all collaborators produces bogus times that cannot be used for local dates. Is there an operator to add in the formula that corrects the glitch from the source datetime field, or is there a way to “lock-in” the time in the base so that GMT doesn’t muck things up?
Solved! Go to Solution.
Aug 09, 2022 02:15 PM
You need to use SET_TIMEZONE()
.It is documented in the Formula Field Reference.
DATETIME_FORMAT(
SET_TIMEZONE({Session 00 Start Time}, 'America/Los_Angeles'),
'LT'
)
Aug 09, 2022 02:15 PM
You need to use SET_TIMEZONE()
.It is documented in the Formula Field Reference.
DATETIME_FORMAT(
SET_TIMEZONE({Session 00 Start Time}, 'America/Los_Angeles'),
'LT'
)
Aug 09, 2022 02:39 PM
Exquisite! Thanks @kuovonne!