I need to design a query that checks the calendar days a part-timer missed. Meaning - even if they work just 1 day a week, I still need to be notified if they missed 14 calendarial days (which are just 2 days according to their work pattern).
Describe the Challenge | It'll make it possible for us to follow up on people missing for a long time, regardless of their work pattern. |