Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Week Function
Message
 
To
15/12/2008 18:38:28
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows NT
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01367670
Message ID:
01367711
Views:
10
>Hi
>
>
>WEEK(DATE(2008,12,29)) returns 1.. Does anyone has dealing with that? How to solve?
>
>TIA

Interesting behavior found when I tried a few things. It seems that SET FWEEK is ignored by the WEEK function but,
?WEEK({^2008/12/29},3) && returns 52

but
SET FWEEK TO 3
?WEEK({^2008/12/29}) && Returns 1
I guess it is best to put the second argument in the WEEK function if you want accuracy.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform