Calculate difference between two workdays

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top