Forum Discussion

KevinJan's avatar
KevinJan
Regular Visitor
4 years ago
Solved

Determine Shift based on TimeStamp

Hi All,   I need help to determine the shift based on the time stamp of my data set.  Day Shift = 6:00:00 AM to 6:00:00 PM Night Shift = 6:00:00 PM to 6:00:00 AM (the next day)   Any help...
Need Help
  • mwegener's avatar
    mwegener
    4 years ago

    Hi KevinJan ,

    maybe this will help.

    if DateTime.Time([time]) > Time.From("6:00:00") and DateTime.Time([time]) < Time.From("18:00:00") then "Day Shift" else "Night Shift"

     

mh2587's avatar
mh2587
Super User
4 years ago

column=
VAR _A =
TIME ( 6,00,00 )
VAR _B =
TIME ( 18,00,00 )

RETURN
IF (
[Time Coulmn] >= _A
&& [Time Coulmn] <= _B,
"Day Shift","Night Shift" )