The FIYR function returns the financial year, also known as the fiscal year, corresponding to a given calendar date based on the financial year starting date and the financial year numbering convention.
Since Dialogue Manager interprets a date as alphanumeric or numeric, and FIYR requires a standard date stored as an offset from the base date, do not use FIYR with Dialogue Manager unless you first convert the variable used as the input date to an offset from the base date.
For more information, see Calling a Function From a Dialogue Manager Command.
FIYR(inputdate, lowcomponent, startmonth, startday, yrnumbering, output)
Is the date for which the financial year is returned. The date must be a standard date stored as an offset from the base date.
If the financial year does not begin on the first day of a month, the date must have Y(Y), M, and D components, or Y(Y) and JUL components (note that JUL is equivalent to YJUL). Otherwise, the date only needs Y(Y) and M components or Y(Y) and Q components.
Is one of the following:
1 through 12 are used to represent the starting month of the financial year, where 1 represents January and 12 represents December. If the low component is Q, the start month must be 1, 4, 7, or 10.
Is the starting day of the starting month, usually 1. If the low component is M or Q, 1 is required.
Valid values are:
FYE to specify the Financial Year Ending convention. The financial year number is the calendar year of the ending date of the financial year. For example, when the financial year starts on October 1, 2008, the date 2008 November 1 is in FY 2009 Q1 because that date is in the financial year that ends on 2009 September 30.
FYS to specify the Financial Year Starting convention. The financial year number is the calendar year of the starting date of the financial year. For example, when the financial year starts on April 6, 2008, the date 2008 July 6 is in FY 2008 Q2 because that date is in the financial year that starts on 2008 April 6.
I, Y, or YY
The result will be in integer format, or Y or YY. This function returns a year value. In case of an error, zero is returned.
Note: February 29 cannot be used as a start day for a financial year.
The following request against the CENTSTMT data source obtains the financial year corresponding to an account period (field PERIOD, format YYM) and returns the values in each of the supported formats: Y, YY, and I4.
DEFINE FILE CENTSTMT FISCALYY/YY=FIYR(PERIOD,'M', 4,1,'FYE',FISCALYY); FISCALY/Y=FIYR(PERIOD,'M', 4,1,'FYE',FISCALY); FISCALI/I4=FIYR(PERIOD,'M', 4,1,'FYE',FISCALI); END TABLE FILE CENTSTMT PRINT PERIOD FISCALYY FISCALY FISCALI BY GL_ACCOUNT WHERE GL_ACCOUNT LT '2100' END
On the output, note that the period April 2002 (2002/04) is in fiscal year 2003 because the starting month is April (4), and the FYE numbering convention is used:
Ledger Account PERIOD FISCALYY FISCALY FISCALI ------- ------ -------- ------- ------- 1000 2002/01 2002 02 2002 2002/02 2002 02 2002 2002/03 2002 02 2002 2002/04 2003 03 2003 2002/05 2003 03 2003 2002/06 2003 03 2003 2000 2002/01 2002 02 2002 2002/02 2002 02 2002 2002/03 2002 02 2002 2002/04 2003 03 2003 2002/05 2003 03 2003 2002/06 2003 03 2003