Function: CalendarWeek
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
Note:
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.
© 2024 Altair Engineering Inc. All Rights Reserved.