- Contents
- Index
- Search
Display results with all search words
gtCVYear
You must enter these parameters into this function call so that information can be retrieved from, or updated to, the correct financial year in Greentree Desktop. The Excel function will carry out any date conversion needed before passing the date to Greentree Desktop for conversion into a Financial Year.
Company
The company code that information is to be retrieved from or updated to.
InputDate.
The date being converted. This must be a standard Excel date.
RelativePeriod
This is the number of periods (+/-) to move from the period that the conversion date falls into. For example, +1 moves one period ahead and return the financial year that the period belongs to, while 12 moves 12 periods back into history and return the financial year that the period belongs to.
Returns
The Financial Year description.
Examples
=gtCVYear (01, 31/03/2001) returns:
2001 - the description of the year in the MARCH calendar to which the date 31/03/2001 belongs.
=gtCVYear (01, 31/03/2001, -12) returns:
2000 - the description of the year in the MARCH calendar that is 12 months less than that to which the date 31/03/2001 belongs.
Errors Returned
- Must have a Company identifier
- Invalid Company identifier
- Must have a date defined
- Financial Year does not exist for this date
- Invalid Relative Period