>>WEEK(DATE(2008,12,29)) returns 1.. Does anyone has dealing with that? How to solve?
>
>What value are you expecting? What's the context of that date value? Calculating the week number is not just a question of the date. There are other conditions to consider as well.
>
>For example, here in Germany (and many other countries in Europe), week #1 would be correct, for this date.

IMO... due to the creation of a year timeline object... Week #53 sound the most logic answer for any western country.. because it isn't the first week of the year, but the last one.. because it starts on the year of 2008

DEC 08  week 49      week 50      week 51      week 52      week 53
[]                       |            |            |            |           []
[]--------------------------------------------------------------------------[]
[]                       |            |            |            |           []