@CalcMgrExcelYEARFRAC
Purpose:
Returns the year fraction representing the number of whole days between start_date
and end_date
Syntax:
Java Class: com.hyperion.calcmgr.common.excel.cdf.ExcelDateTimeFunctions.YEARFRAC(double,double,double)
CDF Spec: @CalcMgrExcelYEARFRAC(startDate, endDate, basis)
Note:
If you are passing a date in a Oracle Hyperion Planning date format, you must convert the Planning date to an Excel date using @CalcMgrDateToExcel.
Note:
Date parameters used in @CalcMgrExcel
functions must be in an Excel format. See @CalcMgrExcel Custom Functions with Date Parameters.