G Guest Apr 5, 2004 #1 I'm attempting to add 15 workdays to a given date. Any suggestions, I'm coming up blank
C Chris2 Apr 5, 2004 #2 Travis Grob said: I'm attempting to add 15 workdays to a given date. Any suggestions, I'm Click to expand... coming up blank dateadd("d", 15, #01/01/2004#) Output: 01/16/2004
Travis Grob said: I'm attempting to add 15 workdays to a given date. Any suggestions, I'm Click to expand... coming up blank dateadd("d", 15, #01/01/2004#) Output: 01/16/2004
G Guest Apr 5, 2004 #3 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.
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 Apr 5, 2004 #4 Travis Grob said: Thanks, but I'm only trying to add workday, not total days. 1/1/04 would Click to expand... by 1/22/04. Excel has the function, but I can't seem to get it in Access. 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
Travis Grob said: Thanks, but I'm only trying to add workday, not total days. 1/1/04 would Click to expand... by 1/22/04. Excel has the function, but I can't seem to get it in Access. 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
