Function: FiscalQtr
Description
Returns the number (1-4) of the fiscal quarter in which the given date falls.
Syntax
FiscalQtr(date).
Arguments
Date may be any valid date in the range 1/1/1601-12/31/2400
Return Value
This function returns a number (1-4).
Calculated field example
The following expression will display 2 for a Ship Date field containing 4/1/2008: FiscalQtr([Ship Date])
Filter/find example
Records with a ship date that falls within the first fiscal quarter can be selected or found using the following expression: FiscalQtr([Ship Date])=1
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.