FiscalPeriod Function

Description

Returns the number (1-13) of the fiscal period in which the given date falls.

Syntax

FiscalPeriod(date).

Arguments

Date may be any valid date in the range 1/1/1601-12/31/2400.

Return Value

This functions returns a number (1-13), representing the quarter in which date falls.

Calculated field example

The following expression would return 3 for a Ship Date field containing 3/1/2008: FiscalPeriod([Ship Date])

Filter/find example

Records with ship dates that fall within fiscal periods 1 through 7 can be found with the following expression: FiscalPeriod([Ship Date])<=7

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.