In my web app, a webuser submits a form and the date/time submitted is recorded in the db. The form is then put on a queue for processing.
Now, when an employee logins into the app and processes the forms on the queue, the time from when the form was submitted minus the time it was processed is recorded via the datediff function.
The problem that I face, is that the date difference is including weekends(non-business) and holidays, thus, producing invalid data when running reports.
For example, if a form is submitted on friday and not processed until monday, the date diff would record more than 48 hours.
How can I detect weekends and holidays using ASP.NET VB?