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