Subtract 1 business day

[red41]

In my database I have a field named FileDate. I would like to include another field named AdjDate. AdjDate=FileDate unless FileDate is a weekend or a holiday.

If FileDate=a weekend or a holiday, I would like AdjDate=FileDate-1 business day.

Thanks in advance for any help on this question. In the past,I used the WORKDAY function in Excel to master this but cannot do the same in Access97.

 

[MichaelRed]

see my fab faq181-261 for the REAL calc of business / work days. It is NOT your answer, but it is a good look into the REAL work / business days issue.

MichaelRed
m.red@att.net

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

 

[red41]

Thanks for the FAQ link. I had already printed your post off for reference.

The problem I have is that all of these modules/posts calculate working days instead of showing how to add/subtract working days from a given date. Any further hints would be greatly appreciated.

 

[hsitz]

Check out these routines at The Access Web. Should be exactly what you're looking for. With them and/or Michael's FAQ you should be all set:

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