Date calculation

  • Thread starter Thread starter Lori
  • Start date Start date
L

Lori

I am using Access 97. I am trying to write a query where
I need to find out if certain tasks were completed in so
many days. I have a received date and an completion date
and I try to find out if these dates are within 5 days of
each other. The problem I have is that I can't count
weekend days. How can I account for this? Thanks for any
help you can give.
 
Have you tried searching for your answer? Counting only weekdays is a very
common question and has been asked and answered many times in these groups.

Rick B


I am using Access 97. I am trying to write a query where
I need to find out if certain tasks were completed in so
many days. I have a received date and an completion date
and I try to find out if these dates are within 5 days of
each other. The problem I have is that I can't count
weekend days. How can I account for this? Thanks for any
help you can give.
 
Back
Top