FiscalYear Function

Description

Returns the year number of the fiscal year in which the given date falls. If at_start is 0 or not given, then the fiscal year is numbered for the calendar year in which it ends. If at_start is non-zero, then the fiscal year is numbered for the calendar year in which it starts.

Syntax

FiscalYear(date,[at_start])

Arguments

Date may be any valid date in the range 1/1/1601-12/31/2400. At_start is a number (0 or 1) that specifies whether the fiscal year is numbered for the calendar year in which it ends (0) or for the calendar year in which it starts (1).

Return Value

This function returns a number.

Calculated field example

If the Ship Date field contained 1/8/2008, the following expression would return 2008: FiscalYear([Ship Date],0)

Note: If the expression was modified to FiscalYear([Ship Date],1), 2007 would be returned.

Filter/find example

The following expression would select or find all the records in which the ship date falls within the 2008 fiscal year: FiscalYear([Ship Date],0)=2008

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.