Welcome! Log In Create A New Profile


WD5.5 => WD15: WeekNumber(Function) doesn't work

Posted by Jimbo 
WD5.5 => WD15: WeekNumber(Function) doesn't work
November 21, 2010 07:11PM


Warning: Results from using WeekNumber(Function) and DateToWeekNumber(Function) can be wrong!

In general, WeekNumber(Function) is an ISO 8601 week number calculation but yields wrong results around the year's end / beginning! The 'examples' in Help will make you aware of the fact somehow but will not explicitely tell you that something is wrong here and how it could be fixed. See our web site for a short description of calendar week calculation and a suggested fix of the problem. See my annotation to the function. Same applies to the DateToWeekNumber(Function) which is a duplicate of WeekNumber(Function).


Your Email:


Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.