FIYYQ: Obtaining the Financial Year and Quarter

How to:

The FIYYQ function will determine both the financial year and quarter corresponding to a given calendar date.

Top of page
x
Syntax: How to Obtain the Financial Year and 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 Y(Y)Q or QY(Y). This function returns a smart data. In case of an error, zero is returned.

iWay Software