Feb 16, 2021 01:33 PM
Hi everyone!
Does someone know how could i change this “2021-02-16T21:30:18.110Z” (text type field) to a date and time format and change the time zone (the hour is coming with 5 hours of difference of what it should be, it says. “21:30” when it should be. “16:30”.
Thank you so much in advanced!
Feb 16, 2021 03:03 PM
You want to use a combination of the DATETIME_FORMAT()
and SET_TIMEZONE()
functions.
For example
DATETIME_FORMAT(
SET_TIMEZONE({your date/time field}, 'America/New_York'),
'M/D/YYYY h:mm'
)
They are documented in the formula field reference.
Feb 17, 2021 07:09 AM
thanks. for your response! One question, what if the field looks like this.: “2021-02-16T21:30:18.110Z” that would. be. “YYYY-MM-DD h:mm:ss”? or how should i put it?
Feb 17, 2021 08:17 AM
You can find all the format specifiers on this page: