>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.
Holger Vorberg
Germany