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