T
Travis Grob
I'm attempting to add 15 workdays to a given date. Any suggestions, I'm coming up blank
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Chris2
coming up blankTravis Grob said:I'm attempting to add 15 workdays to a given date. Any suggestions, I'm
dateadd("d", 15, #01/01/2004#)
Output:
01/16/2004
T
Travis Grob
Thanks, but I'm only trying to add workday, not total days. 1/1/04 would by 1/22/04. Excel has the function, but I can't seem to get it in Access.
C
Chris2
by 1/22/04. Excel has the function, but I can't seem to get it in Access.Travis Grob said:Thanks, but I'm only trying to add workday, not total days. 1/1/04 would
Oh, sorry, you're right.
That's much more complicated.
See Website:
Date/Time: Doing WorkDay Math in VBA
http://www.mvps.org/access/datetime/date0012.htm