Calendarweek

[#1]

1-01-2012 = week 52 and i most be week1

can someone help me ?

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

If you require that all weeks start on first of January, you can use

LunarWeekName(FieldDate) AS Week

Hope that helps.

Miguel