YEAR_DIFFERENCE
Description
Calculates the calendar year difference between the two dates as an integer constant. Year difference between 31/12/2004 and 01/01/2005 is 1.
Syntax
YEAR_DIFFERENCE (date1, date2)
Can be used in the condition of a FIND action.
Parameters
Two attributes of the Date type or date constants or calculations producing a date
Returns
Number: the calendar year difference between the two dates (31/12/2004 to 01/01/2005 is 1).
Example
IF YEAR_DIFFERENCE (Account.OpeningDate, Account.ClosingDate) = 5 THEN ...