DateAdd question

J

jamal19

I am trying to use DateAdd("w",[value],[Ship Date]) to add business offset
days, but the function simply adds days, not working days?! Any help is
greatly appreciated. I am using this in a query update to modify my table
data. I am using Access 2003. Thanks for any help on this.
 
J

jamal19

Thanks smartin....that helps a lot.

smartin said:
jamal19 said:
I am trying to use DateAdd("w",[value],[Ship Date]) to add business offset
days, but the function simply adds days, not working days?! Any help is
greatly appreciated. I am using this in a query update to modify my table
data. I am using Access 2003. Thanks for any help on this.

Perhaps have a look at this:

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

Also google 'work days access'. HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top