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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Microsoft Access Date Calculation 1
Calculating a Date 1
Date Calculation 1
Date Calculation 1
Calculated Field in Query - Date Format 5
Access Count dates within a Month 4
Date Evaluation 1
Calculating Work Dates 9

Back
Top