Calculaeate Difference Excluding Weekends

[Sumanth.Ganjam]

Hi All,



I am trying to Calculate the Date difference between "Material Submit Data" and "Current Date" excluding Weekends.

Please help how to write the query for this one.

Thanks
Sumanth.

[Bob Fitz]

I think you will need to create a function that can be called from a query to get the desired results.
The attached db has a function in it called BusinessDays() that will return the number of Business Days between the two dates parsed to it.
The function will exclude public holidays as well as weekends. If you want to include public holidays in your calculation you would need to amend the function.
Post back if you need help with that.

[Sumanth.Ganjam]

Thanks Bob for sharing this one.