CurrentFY()

<< Click to Display Table of Contents >>

Navigation:  Available Functions >

CurrentFY()

Syntax

CurrentFY()

 

Purpose

To retrieve the current fiscal year for your organization during a report or other process.

 

Parameters

None.

 

Returns

Return the current fiscal year for your organization.

 

Usage

Many organizations have a fiscal year that is different from the calendar year. For example, where the calendar year starts on January first, fiscal years commonly start on July first. If today's date were June 30, 2011, and your fiscal year begins July 1, then today would be the last day of the fiscal year 2011. Tomorrow would be the first day of fiscal year 2012. Generally speaking, at any point in time the fiscal year is usually either equal to, or one greater than the calendar year.

 

Once you have told DonorQuest the starting month for your fiscal year, and the current fiscal year (via the fiscal year settings option described in section seventeen), DonorQuest will automatically keep track of the fiscal year donation totals for you. Also, DonorQuest will automatically increment the current fiscal year by one at the end of each fiscal year.

 

The CurrentFY() function can be used in reports and selection conditions to retrieve the current fiscal year at anytime. You can use the CurrentFY() function in combination with other fiscal year functions to select specific donations. For example, if you wish to select all of the donations for the current fiscal year, you could use the following selection condition:

 

Example

FiscalYearOf( .Donation_Date. ) = CurrentFY()

 

The above example used the FiscalYearOf() function to determine the fiscal year of a donation date so that it could be compared to the current fiscal year. Since calendar dates are used for donation dates, the FiscalYearOf() function is quite valuable in this instance.