Hi Experts,
I am trying to compare two dates "Start Date" and "End Date" in Hyperion planning On Prem version 11.1.2.4.0.79.
The requirement is:
IF ("Start Date" > "End Date")
@RETURN ("Start Date should be greater than the End Date", ERROR);
ENDIF
I tried the date functions @CalcMgrDateDiff and @CalcMgrDaysBetween, but they both give me the number of days between the two dates but not satisfy the condition as above
IF ( @CalcMgrDateDiff ({rtpInstallDate},{rtpStartDate}, "day" ) < 0 )
@RETURN ("Installation Date has to be after the Start Date ", ERROR); /* returns 14 */
ENDIF
IF ( @CalcMgrDaysBetween({rtpInstallDate},{rtpStartDate} ) < 0 )
@RETURN ("Installation Date has to be after the Start Date ", ERROR); /* returns 14 */
ENDIF
How should i perform the check that if "Start Date" should be before "End Date"? Any ideas would be very helpful.
Thanks and Regards,
Pete`