Returns the week number (1-53) of the calendar week in which the given date falls.
Date may be any valid date in the range 1/1/1601-12/31/2400.
This function returns a number.
Calculated field examples
If the Ship Date field contained the date 4/18/2008, the following expression would return 16: CalendarWeek([Ship Date])
Records representing shipments during the first sixteen weeks of the year can be selected or found using the expression: CalendarWeek([Ship Date])<=16
The examples above assume that the following time interval settings have been specified via the Time Intervals wizard:
The fiscal year consists of 12 calendar months starting on the first day of January.
A fiscal week is defined as the first week of the year starts on January 1, regardless of what day of the week it may be.
A calendar week is defined as the first week of the year starts on January 1, regardless of what day of the week it may be.