• Contents
  • Index

Altair® Monarch®

 

Function: FiscalQtr

Description

Returns the number (1-4) of the fiscal quarter in which the given date falls.

Syntax

FiscalQtr(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-4).

Calculated field example

The following expression will display 2 for a Ship Date field containing 4/1/2008: FiscalQtr([Ship Date])

Filter/find example

Records with a ship date that falls within the first fiscal quarter can be selected or found using the following expression: FiscalQtr([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.