Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Weeks in a year
Message
 
To
17/10/2006 15:48:48
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:
01162702
Views:
19
>>>How I know how many weeks has the current year ? (any function o procedure?
>>>
>>>thanks in advance.
>>>
>>>Carlos Burgos
>>
>>What is it a partial week ?
>
>Using the ?WEEK(DATE(2007,12,30)) appears to be "rolling over" the last two days to the next year as the first week since this is a partial week. Not sure if partial weeks should be considered in the next year due to financial accounting (year end closing, fiscal year to end of year, etc). Should this be week 53?

Greg,

2007 year starts on Monday; so you cannot get week 53 for Sunday, WEEK(DATE(2007,12,30)). If you want to count weeks as 7-day intervals, and starting from the first day of the year, then you can use this:
?week({^2007-12-30},3,DOW({^2007-01-01})) && 52
?week({^2007-12-31},3,DOW({^2007-01-01})) &&53
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform