FiscalHalfYear Function
Description
Returns the number (1 or 2) of the fiscal half-year in which the given date falls.
Syntax
FiscalHalfYear(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 if date falls within the first half of the fiscal year (i.e., January 1-June 30), or 2 if date falls within the second half of the fiscal year (i.e., July 1-December 31).
Calculated field example
The following expression will return 1 (true) for any Ship Date field that contains a date of 7/1/2008 to 12/31/2008. FiscalHalfYear([Ship Date])=2
Filter/find example
The following expression will display any records with a Ship Date of 1/1/2008 to 6/30/2008: FiscalHalfYear([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.
(c) 2023 Altair Engineering Inc. All Rights Reserved.