FiscalWeek Function
Description
Returns the week number of the fiscal week in which the given date falls
Syntax
FiscalWeek(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 example
If the Ship Date field contained 3/1/2008 the following expression would return 9: FiscalWeek([Ship Date])
Filter/find example
Orders shipped during the 9th fiscal week could be selected or found with the following expression: FiscalWeek([Ship Date])=9
Note: The example above assumes that the following time intervals settings have been specified via the Time Intervals wizard:
-
The fiscal year consists of 12 calendar months starting on January 1.
-
The fiscal week is defined as the first week of the year that starts on January 1, regardless of what day of the week it is.
-
The calendar week is defined as the first week of the year that starts on January 1, regardless of what day of the week it is.
(c) 2023 Altair Engineering Inc. All Rights Reserved.