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.
Evonsys
US
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.