cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Poojad1 Member
Member

15 shift back

 

Untitled.png

hello i have date from that i want to calculate current shift like system date is 4/3/2018 2:47pm is current time and then find out that shift from
Shift Timing
=================
Shift A: 6AM to 2PM
Shift B: 2PM to 10PM
Shift C: 10PM to 6AM

how to find that shift means current shift,current shift-1,current shift -3.......up to 15th shift....,,,,
suggest some way....

1 ACCEPTED SOLUTION

Accepted Solutions
stefans2403 Frequent Visitor
Frequent Visitor

Re: 15 shift back

You need to calculate start time of current shift using GETDATE() and IF statement.

 

From there, it's easy to calculate shift order using start time of current shift -8 hours,-16 hours,-24 hours, etc. again using IF statement.

2 REPLIES 2
stefans2403 Frequent Visitor
Frequent Visitor

Re: 15 shift back

You need to calculate start time of current shift using GETDATE() and IF statement.

 

From there, it's easy to calculate shift order using start time of current shift -8 hours,-16 hours,-24 hours, etc. again using IF statement.

Poojad1 Member
Member

Re: 15 shift back

Hiii,


Can u explain more!!

 

Regards ,
Pooja