FIYR: Obtaining the Financial Year

How to:

The FIYR function will determine the financial year, also known as the fiscal year, corresponding to a given calendar date.

Top of page
x
Syntax: How to Obtain the Financial Year
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 Y or YY. This function returns a year value.

iWay Software