Extracting Weekdays

[JerSand]

A query in my database computes the number of calendar days elapsed between two dates. The syntax is simply:

SELECT Main.[Date Received], Main.[Date Returned], [Date Returned]-[Date Received] AS [Review Time]
FROM Main;

I would like to change this query so that it counts only workdays -- not Saturdays or Sundays. I'd be grateful for any tips or examples.

Thanks.

JerSand

 

[KenReay]

Hi

See

http://www.mvps.org/access/datetime/date0006.htm

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use

 

[JerSand]

Perfect! Thanks so much for your speedy response, Ken.

Jerry

 

[MichaelRed]

see faq181-261 for a more-or-less complete soloution to the entire issue of WORK days (not the same as just 'weekdays').


MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[JerSand]

Thank you, MichaelRed. I was so wrapped-up in extracting approximately correct periods that I was letting the matter of holidays slide. However, it's clear from the FAQ to which you referred me that greater exactitude is indeed possible. This will be very useful. Thanks.

JerSand