Query for Number of Days
Hi Everyone and Greetings,
I want to write a query which return me number of days from previous days till to date and eliminate non working days i.e. Saturday and Sunday along with my specified days, which are other then Sat and Sun.
i.e. from 1st August 2012 till to date total days = 21 days (if i minus Sat and Sun it will be 15), but if i have any additional bank holidays in mid and i store in predefine setup it should eliminate those days as well.
Thanks in Advance for Help.
I want to write a query which return me number of days from previous days till to date and eliminate non working days i.e. Saturday and Sunday along with my specified days, which are other then Sat and Sun.
i.e. from 1st August 2012 till to date total days = 21 days (if i minus Sat and Sun it will be 15), but if i have any additional bank holidays in mid and i store in predefine setup it should eliminate those days as well.
Thanks in Advance for Help.
0