Date Funtions

[Ryan Huth]

I would like to find a way simular to the Date()-1 command
to get previous days information except to exclude
weekends and holidays. For Example if I am running a
report on Monday if I run date()-1 it would bring back
Sundays info instead of Fridays.

Thank you for the help

 

[Cheryl Fischer]

Ryan,

You might want to take a look at the code here:

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


hth,