Help

Use only the time of the DATETIME field in a formula

Topic Labels: Formulas
600 1
cancel
Showing results for 
Search instead for 
Did you mean: 
mccortes10
4 - Data Explorer
4 - Data Explorer

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"

1 Reply 1

SWITCH(

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

6, "ET",

  12, "PT"

)

 

You can find names of time zones here