Skip to main content

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"

SWITCH(

  HOUR(SET_TIMEZONE({Start Date}, "timezone name")),

6, "ET",

  12, "PT"

)

 

You can find names of time zones here. 

Reply


Terms & Conditions