I have 2 tables for week and calendar days.
first I have so_week
second is calendar_days
from_week : 33
and so on
now I need to get the working days based on from_week to week
for example from 33 to 36 the month is aug, sep, sep, sep i need to get the working days for that month.
any help is highly appreciated..
Thank you so much
it cannot be done with that data
please explain how you would arrive at the right answer for weeks 33 to 36
If we're talking about two random weeks, then it's very simple. You only need to account for possible start of the year and end of the year incomplete weeks.
Otherwise, any week in between is a full week: 7 days total minus the 2 days week-end.
33: 5 days
34: 5 days
35: 5 days
36: 5 days
20 days total. Of course, you need to count down the legal holidays.
Unless you mean something else. Like between two random dates.
You would probably want to make a table of all the weeks in a year, and how many working days are in each week number.
This topic is now archived. It is frozen and cannot be changed in any way.