Skip to main content

Use only the time of the DATETIME field in a formula

  • July 13, 2023
  • 1 reply
  • 8 views
M
Forum|alt.badge.img

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

kuovonne
Forum|alt.badge.img+29
  • kuovonne
  • Brainy
  • 6009 replies
  • July 13, 2023

SWITCH(

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

6, "ET",

  12, "PT"

)

 

You can find names of time zones here. 


Terms & ConditionsAccessibility statement