Forum Discussion
Shift rota added to SQL script
I have a date calendar that I can connect too but one of the asks I always get is what shift was in that day shift 1 or shift 2. the rotation is a 14 day pattern and wanted to understand if I c...
was in that day shift 1 or shift 2.
And how is shift 1 / 2 defined; we can not guess that?
olafhelper it’s
sun 1
mon 2
tue 2
wed 1
thu 1
fri 2
sat 2
then the next week it alternates and continues in this pattern. So if I could create a 14 day number cycle 1-14 then once 14 is reached repeats I can then use a case statement to add the pattern
apologies if this isn’t making sense