calculating dates - please help

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

Guest

having problems calculating shipping dates. this is the situation. customer
orders, product in then schedulled to ship ten business day later (not
including weekends). the approripate days need to be aded on. also product
cannot be shipped on weekend. not sure where to begin. anyone have a
suggestion
 
Not intending to be a smart... .,,,,,, here but, do try a search.

in the above "Search For" fill in "calculating dates" and In: Access, while
I can't remember specifics there are many postings that might help.
 
Arvin Meyer has some code on his site you might find useful:
http://www.datastrat.com/
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, but, if necessary, that requirement can be
worked around (even if only temporarily) if you know VBA & look at the code
for 1 minute.
 
Back
Top