CFLib.org – Common Function Library Project

Description:
Returns the fiscal year for date. If no date is provided, year returned is based on the current timestamp.

Return Values:
Returns a number

Example:

currentFY= getFiscalYear();
currentFY= getFiscalYear(datetime=createdate(2009,10,1));

Parameters:

Full UDF Source:

/**
 * Returns fiscal year for a date
 * 
 * @param date      valid date to determine fiscal year for (Optional)
 * @return Returns a number 
 * @author Bob Clingan (bob@bobclingan.com) 
 * @version 0, March 6, 2010 
 */
function GetFiscalYear() {
        var datetime = now();
        var month = month(datetime);
        if (ArrayLen(Arguments) gte 1) {
        if (IsDate(Arguments[1])) {
            datetime = Arguments[1];
            month = month(datetime);
        } else datetime = Now();
        }
        if(month gte 10)
            return Year(DateAdd('yyyy', 1, datetime));
        else
           return Year(datetime);
    }