function AddSomeDaystoDate
parameter xStartDate, xdaytoAdd
lMynewdate = xStartDate + xDayToAdd
lMynewdate = iif(dow(lmynewDate,2) > 5,lMynewdate + (7 - dow(lmynewDate,2) + 1),lmynewDate)
retu lMyNewDate
I've not tested so there could be some errors :-)
HTH
>Hi all,
>
>How to avoid Saturday and Sunday when used date() + 3 ?
>
>If it falls on both Saturday and Sunday that date() + 3 should skip next
>Monday .
>
>date() is Monday , date()+3 is Thursday OK
>date() is Tuesday, date()+3 is Friday OK
>date() is Wednesday, date()+3 is Saturday not OK
>date() is Wednesday, Date() + 3 + ??? shoul be next monday OK
>how to do this, please assist me in coding ?
>
>TIA