11 Replies Latest reply on Apr 18, 2016 3:41 PM by Extensitech

    calculate shift name from timestamp

    rubinjm

      I have a timestamp field named ROOMED TIMESTAMP and would like to calculate a shift name based on the time. I was going to use the CASE function but can't figure out the right way to enter the time ranges.

       

      The timestamp field looks like 1/24/2016 1:29 PM

       

      The shift names are

      DAY = 0630...1500

      PM = 1501...2300

      NIGHT = 2301...0629