Jul 13, 2023 07:27 AM
Hi,
I need to have a formulated field where if the time in the field "start date" is 6 am it returns "ET" and if it is 12 pm returns "PT"
Jul 13, 2023 07:38 AM
SWITCH(
HOUR(SET_TIMEZONE({Start Date}, "timezone name")),
6, "ET",
12, "PT"
)
You can find names of time zones here.