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