Using Weeks

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.


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: