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

@CalcMgrDaysDiff

Purpose:

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

Syntax:

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

CDF Spec: @CalcMgrDaysDiff(fromDate,toDate)

Note:

When using @CalcMgrDaysDiff, if the first date is later than then 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 @CalcMgrDaysBetween.