Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date() + 3
Message
From
22/07/2005 12:15:46
 
 
To
21/07/2005 22:58:35
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
01034976
Message ID:
01035156
Views:
12
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
Previous
Reply
Map
View

Click here to load this message in the networking platform