Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Weeks in a year
Message
From
17/10/2006 21:12:13
 
 
To
17/10/2006 16:01:25
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01162585
Message ID:
01162788
Views:
19
Hi Greg,

check out help on SET FDOW, SET FWEEK and WEEK(), those may help explain what you are seeing.

>>?WEEK(DATE(2007,12,29)) && returns 52 because is Saturday
>>
>>>?WEEK(DATE(2007,12,30)) && returns 1 because is Sunday
>>
>>It´s not a bug but a feature.
>
>But what dictates that 30-Dec-2007 is week 1 and not week 53 in year 2007? If you look at 30-Dec-2005, it returns week 53 (so it is possible to have more than 52 weeks in a year). Why not consider the last two days as week 53 for year 2007?
Frank.

Frank Cazabon
Samaan Systems Ltd.
www.samaansystems.com
Previous
Reply
Map
View

Click here to load this message in the networking platform