General information
Category:
Coding, syntax & commands
>>>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only