YEAR_DIFFERENCE

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.

Two attributes of the Date type or date constants or calculations producing a date

IF YEAR_DIFFERENCE (Account.OpeningDate, Account.ClosingDate) = 5 THEN ... 
  • Last modified: 2023/05/09 01:25