Forum Discussion
15 shift back
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....
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
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.