15 shift back

[Anonymous]

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....

[stefans2403 · Accepted solution]

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.

[Anonymous]

Hiii,

Can u explain more!!

Regards ,
Pooja