• Contents
  • Index

Altair® Monarch®

 

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.