Table of Contents

, ,

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 ... 

FULL_YEARS, MONTH_DIFFERENCE, DAY_DIFFERENCE, AGE