Create Production Shift Category base on time stamp data

Anonymous , Based on what I got.

You can create a new column

Time bucket =

Switch( True() ,

timevalue([Datetime]) >= time(7,0,0)  && timevalues([Datetime]) < time(19,0,0)  , "Day Shift",

"Night Shift"

)

Date column to use

Date =

Switch( True() ,

timevalues([Datetime]) < time(7,0,0)  , datevalue([Datetime])  -1,

datevalue([Datetime]) 

)

This will give you date and shift to be used