Hi Friends,
I have a question that how to make shifts out of Datetime column:
I have scheduled datetime (ex: Nov 3, 2017 8:00:00 PM) dataitem in my query. out of that data item how can I make a shifts like below. for ex if I run the report for startdate 11/03 and enddate 11/03
(5am to 5pm 1st shift and 5pm to 5am is the 2nd shift)
11/03 11/03
05:00 to 16:59 17:00 - 04:59
I can make shifts like datetime between 5 to 17 is ist shift else 2nd shift but here second shift is 5pm to 5am so it is making me confused how to use add_days or some other function in the expression.
it might be very easy for some of you so please help me.
Thanks in advance