FIQTR: Obtaining the Financial Quarter

How to:

The FIQTR function will determine the financial quarter corresponding to a given calendar date.


Top of page

x
Syntax: How to Obtain the Financial Quarter
FIYR(inputdate, lowcomponent, startmonth, startday, yrnumbering, result)

where:

inputdate

Numeric

lowcomponent

Alphanumeric

Is one of the following:

  • D if the date containts a D or JUL componen.
  • M if the date contains a M component, but no D component.
  • Q if the date contains a Q component.
startmonth

Numeric

1-12 is used to represent a financial year starting in January and going to December.

startday

Numeric

1, or another starting day in the starting month.

yrnumbering

Alphanumeric

FYE or FYS is used.

result

Numeric

The result will be in integer format, or Q. This function will return a value of 1-4.


iWay Software