get previous business date

[iccsi]

I wanted to have a function to get previous business date function.
Are there any available?
I can do that check weekday and - 2 if it is Monday.
Any way to take care of holiday?
Is a function available in the Access?
Your information is great appreciated,

 

[Daniel Pineault]

Take a look at http://www.mvps.org/access/datetime/date0012.htm I believe it
should be what you are looking for. You may also want to check out there
other date/time function at http://www.mvps.org/access/datetime/index.html
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.com/index.php
Please rate this post using the vote buttons if it was helpful.