CalendarWeek Function

Description

Returns the week number (1-53) of the calendar week in which the given date falls.

Note: Although this function is similar to the Week function, it numbers weeks according to the current settings on the Time Intervals Options dialog.

Syntax

CalendarWeek(date)

Arguments

Date may be any valid date in the range 1/1/1601-12/31/2400.

Return value

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])

Filter/Find example

Records representing shipments during the first sixteen weeks of the year can be selected or found using the expression: CalendarWeek([Ship Date])<=16

Notes

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.