Excluding weekends and holidays from date results.

[apolite]

Hi, I want to thank those who helped me in the code to adjust the date
depending on the time of day. I have another question brought on by the
foresight of someone in the community. The code that I am using
"=IIf(TimeValue(Now())>#2:00:00 PM#,Date()+1,Date())", works fine. I am
wondering if there is any way to post dates that would result in only
business working days just as a bank would for posting a deposit date
depending on the time of day. Any suggestions of ideas would be greatly
appreciated.

Thank You

 

[Douglas J. Steele]

Take a look at http://www.mvps.org/access/datetime/date0012.htm at "The
Access Web", or 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