- Contents
- Index
- Search
Display results with all search words
gtCVPeriod
You must enter these parameters into this function call so that information can be retrieved from, or updated to, the correct financial period 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 Period.
Company
The company code that the 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 description for that period, while 12 moves 12 periods back into history and return the description for that period.
Returns
The Financial Period Description.
Examples
=gtCVPeriod (01, 31/03/2003) returns:
March - the description of the period in the company 01 calendar (MARCH) to which the date 31/03/2003 belongs.
=gtCVPeriod (01, 31/03/2003, -1) returns:
February - the description of the period in the company 01 calendar (MARCH) that is 1 period less than that to which the date 31/03/2003 belongs.
Errors Returned
- Must have a Company identifier
- Invalid Company identifier
- Must have a date defined
- Financial Period does not exist for this date
- Invalid Relative Period