Hi,
I know problem can be simple. I have start date, end date, table with holidays. Problem is I have addition criteria, day(s) of week.
For example from January 1, 2010 to December 31, 2010 I will work for example Monday, Friday and Saturday. Question is how many days I will work excluding holidays.
I have to receive in the end three number:
1. total number of days: this is simple Datediff
2. Number of potentital work day. For it I made query what count number of Monday, Friday and Saturday.
3. real number days, so without holidays. For example May 1 is Saturday so not work.
How can I do it? Possible in simple query?
I know problem can be simple. I have start date, end date, table with holidays. Problem is I have addition criteria, day(s) of week.
For example from January 1, 2010 to December 31, 2010 I will work for example Monday, Friday and Saturday. Question is how many days I will work excluding holidays.
I have to receive in the end three number:
1. total number of days: this is simple Datediff
2. Number of potentital work day. For it I made query what count number of Monday, Friday and Saturday.
3. real number days, so without holidays. For example May 1 is Saturday so not work.
How can I do it? Possible in simple query?