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.