cancel
Showing results for
Did you mean:
Highlighted
Member

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

1 ACCEPTED SOLUTION

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

Member

## Re: 15 shift back

Hiii,

Can u explain more!!

Regards ,
Pooja