1. Designing with Calculation Manager for Oracle Enterprise Performance Management Cloud
  2. Using Member Selection, Variables, Functions, Smart Lists, and Planning Formula Expressions to Design Components
  3. Working with Custom Functions
  4. Date/Time Functions
  5. @CalcMgrYearsDiff

@CalcMgrYearsDiff

Purpose:

Returns the years between two dates that are in the YYYYMMDD format

Syntax:

Java Class: com.hyperion.calcmgr.common.cdf.CalendarFunctions.yearsDiff(int,int)

CDF Spec: @CalcMgrYearsDiff(fromDate,toDate)

Note:

When using @CalcMgrYearsDiff, if the first date is later than the second date in the function, then a negative number is returned. If the first date is before the second date in the function, then a positive number is returned. If you want to return only positive numbers, then use @CalcMgrYearsBetween.