Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Week Function
Message
From
16/12/2008 09:58:56
 
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:
01367869
Views:
11
>>>>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
>>>
>Read the help file about the secondf argument to the week function adn you will see that you can control what is concidered tthe first week of the year and therefore what week 12/29 fals in.
? WEEK({^2008-12-28},2)
brought me 53 (what sounds logical to me)... but I'm a little affraid if in others years I'll reach others behaviors... But, anyway... This is what may I use from now own...

tks Jim
"Now to him who is able to do immeasurably more than all we ask or imagine, according to his power that is at work within us, Ephesians 3:20
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform