WEEKNUM() not ISO proof


#1

Hi, to be honest I’m not sure if it actually is a bug, but this function does not follow the ISO standard of numbering weeks.

For example, today (2016-10-13) should be week 41, but the function returns 42. Probably because the first week of this year was week 53 according to the international standards.


#2

Never mind: I just found that DATETIME_FORMAT(NOW(), ‘W’) does return the ISO week number.

A reference in the formula editor (for WEEKNUM) would be helpful. :slight_smile: