Calculating Dates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

burnspaul@hotmail.co.uk - 15 Jan 2008 16:54 GMT

I need to input a date into one field and have access show me a
another date (plus 20 days) in another field (which I can do) but
here
is where I need help. I need to exclude Saturdays & Sundays and Bank
Holidays. Can anyone one help please

Reply to this Message

Douglas J. Steele - 15 Jan 2008 17:02 GMT

Take a look in the Date/Time section of "The Access Web"
http://www.mvps.org/access/ There are a couple of possibilities there. You
could also take a look at my September, 2004 "Access Answers" column in
Pinnacle Publication's "Smart Access". You can download the column (and
sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>I need to input a date into one field and have access show me a
> another date (plus 20 days) in another field (which I can do) but
> here
> is where I need help. I need to exclude Saturdays & Sundays and Bank
> Holidays. Can anyone one help please

Reply to this Message