G
Guest
Guest
Help.
I am tasked with calculating five working day intervals for start and end times, not including weekends.
The start date may be a Monday, with the job due on a Friday - easy - five days total.
The problem is when I get a start day on a Tuesday and then the finish day on the next Monday (the weekend days are included even though they don't really count as working days) the total days works out to seven (when in actual fact, the duration is five working days).
How can I set this up so that the weekend days are omitted in my query?
I am tasked with calculating five working day intervals for start and end times, not including weekends.
The start date may be a Monday, with the job due on a Friday - easy - five days total.
The problem is when I get a start day on a Tuesday and then the finish day on the next Monday (the weekend days are included even though they don't really count as working days) the total days works out to seven (when in actual fact, the duration is five working days).
How can I set this up so that the weekend days are omitted in my query?
