Calculate difference between two workdays

D

Dates

Is it possible to create a query that calculates difference between two
Business Days excluding weekends? I've seen the posts, and it all involves
VB code?

Thanks
 
J

JohnFol

For a given pair of dates on a single row, a query can do a single task with
them, ie add them, subtract etc. What you are asking for is some sort of
loop to enumerate each date in the range and determine if a counter should
be incremented absed upon some business rules during that single read of the
row. It can't be done, hence why the solution is code



No, you need to do it in code as for each dat between the two dates
 
Top