adding days and half days

[newbie404]

I am trying to write a function where I add a number of days or half days to a date. however, I am not sure how to add days of the week (M-F) only when adding days.

I thought that it was newdate=DateAdd("w", 1, indate)
but this seems to just add a single day even if it is adding to friday. I want to do it so that I can pass in 12 or 14 or similar days and t will add that number of working days.

Is there an easy way to do this before I write a big complex function?

thanks

 

[sdraper]

newdate=DateAdd("ww", 1, indate)
yyyy Year
q Quarter
m Month
y Day of year
d Day
w Weekday
ww Week
h Hour
n Minute
s Second



Sam

 

[newbie404]

Thanks, but that's not working for me. I found a script that works at

http://www.flws.com.au/showusyourcode/codeLib/code/AddWorkingDays.asp?catID=1

Thanks for the help anyhow, but it was weekdays not weeks I was trying to add. And weedays as 'w' seems to just add a day (even if that day is saturday or sunday)

 

[sdraper]

Ahh.. I misunderstood the question. Even though the help says "w" will add weekdays(M-F) you are correct it doesn't. interesting.

Sam