Function: HalfYear
Description
Returns the number (1 or 2) of the calendar half-year in which the given date falls.
Syntax
HalfYear(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 or 2).
Calculated field example
The following expression will return 1 from a Ship Date field containing 3/1/2008: HalfYear([Ship Date])
Filter/Find example
Orders shipped during the second half of the year can be selected or found using the expression: HalfYear([Ship Date])=2
Note: The examples above assume 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.