Date Difference, Excluding certain Times and Dates
- by Josefvz
Hi Folks.
I'm looking for a way to determine the difference between two dates.
A normal SQL DATEDIFF statement won't cut it because I need to excluded non working Hours and days Namely Weekends and any time between 16:00 - 7:00.
Something similar to the NETWORKDAYS function in excel.
I'm codeing an excel spreadsheet. Using VBA connect to a SQL server to pull data.