Question
IN
Last activity: 12 May 2021 7:59 EDT
Compare two date values
Hi, I have a requirement two compare two dates and to find which one is latest I have used this when condition in a Data Transform .EventDate>.CurrentDateTime While saving I haven't got any error, while running i got below exception from logs: Exception caught while evaluating when][STACK][java.lang.RuntimeException: Scalar query .CurrentDateTime on page. Can anyone suggest me what is the alternative I can use in case of above when rule. Thanks in Advance.
Regards, Sree Ramya G.
***Edited by Moderator: Pallavi to move from Pega Academy to Product***
Accepted Solution
Updated: 27 Nov 2020 6:03 EST
IN
I have used @DateTimeDifference(.EventDate,.CurrentDate, "D")>0. Issue is resolved and working as expected without any execptions.
Blue Rose Technologies
DE
You can use below one of the expressions below based on whether EventDate is a Date or DateTime property.
For Date:
@DateTime.CompareDates(Param.EventDate,getCurrentDateStamp())
For DateTime:
@DateTime.CompareDateTimeStamp(Param.EventDateTime,CurrentDateTime())
Please see screenshots below,
Accepted Solution
Updated: 27 Nov 2020 6:03 EST
IN
I have used @DateTimeDifference(.EventDate,.CurrentDate, "D")>0. Issue is resolved and working as expected without any execptions.