rotational shift change

Feb 16 2018 3:26 AM

NO Code In Out date shift Absent/Present

63089 2 9:00 18:00 2018-11-28 00:00:00.000 0 G P

63090 2 9:00 18:00 2018-11-29 00:00:00.000 0 G P

63091 2 9:00 18:00 2018-11-30 00:00:00.000 0 G P

i have G A B C shits so need to rotational chage based on date in sql or C#

please help me

Answers (1)

weekly base shift change