Click the Weeks check-box;
select the first day of the week;
then select one of the four conventions that defines the first week of the year:
Jan 1st |
The first week of the year is the week in which January 1 occurs. |
First four days |
The first week of the year is the first week that has at least four days in the new year. Note! Selecting this option, week starting on Monday corresponds to the ISO 8601 standard, widely adopted in Europe (see below details on the ISO standard). |
First full week |
The first week of the year is the first full week of the year. |
B.Prev.version |
Convention adopted in prior Board versions (version 4.x and earlier versions). Select this option if you need compatibility with Board databases built using version 4.x or older. |
Selecting one of the first three options, the week description can be customized using the variables nn representing the week number and YY representing year.
Format definition examples
Format definition |
Resulting entity occurrences |
Week nn/YYYY |
Week 01/2009 , Week 02/2009 …etc… |
W.nn of YY |
W.01 of 09 , W.02 of 09…etc… |
The description cannot exceed 15 characters in length.
When Board’s prior week convention is selected, the options to define the description are:
Desc = Week Nr. |
Week number |
Desc = Date |
Date of the last week day |
Details on the ISO 8601 standard
ISO 8601 "Data elements and interchange formats – Information interchange - Representation of dates and times" - ISO 8601 : 1988 (E) paragraph 3.17:
"week, calendar: A seven day period within a calendar year, starting on a Monday and identified by its ordinal number within the year; the first calendar week of the year is the one that includes the first Thursday of that year. In the Gregorian calendar, this is equivalent to the week which includes 4 January."
This can be implemented by applying these rules for Calendar weeks: