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.

 

 

 

(c) 2023 Altair Engineering Inc. All Rights Reserved.

Intellectual Property Rights Notice | Technical Support