How do I keep Access from returning a Saturday/Sunday?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to write a function within Access to add a number of days to the
current date. However, I want the returned date to only be a weekday; never
a weekend date.
 
Do a search. Date math using business days is a very common topic. Read
the previous posts.
 
FYI, I also had the following pasted in my personal "helpful hints"
document...

Arvin Meyer has some code on his site you might find useful:
http://www.datastrat.com/ and go to Downloads>CodeDownloads :
GetBusinessDay.

A very straightforward function where you supply today's date and how many
Bdays in the future/past you want returned. It requires a "Holidays" table.
 
Rick,

Thanks for your help. My logic in understanding the "weekday" function was
flawed. Thanks for the quick follow-up.
 
Back
Top