Question
John Deere
IN
Last activity: 9 Sep 2019 4:02 EDT
How to validate date using when rule
Hi,
I want to write a generic parameterized when rule which should accept the parameters from Data Transfrom and check whether the date is in valid format or not. if the Date is not in valid format then it should not set the date field(Generally if the date field is blank pega will take the default date as 01011970).
Can you please let me know how can this be achieved?
Thanks.
Yogesh.
Accepted Solution
John Deere
IN
Hi ,
I was able to pass the date from DT to when rule and was able to validate the date using @DateTime.CompareDate() function.
Ernst & Young LLP
MT
You can use a WHEN rule when there is an OOTB function to validate if the string value contains a date/time in correct format.
I could not find one; not sure if such function really exists.
In my opinion, you can create a custom function to take string param that holds the date/time value and validate that with a code similar to the following (I grabbed it from one of the OOTB rule), and use that in your data transform.
String format = myStepPage.getProperty("QuestionFormat").getStringValue();
ClipboardProperty answer = myStepPage.getProperty("pyAnswer");
String answerValue = answer.getStringValue();
if(answer != null && !"".equals(answerValue)){
if("date".equals(format)){
if(com.pega.ibm.icu.math.BigDecimal.ZERO == com.pegarules.generated.pega_rules_string.toDate(answerValue)) {
answer.addMessage("InvalidDateValue\t" +answerValue);
}
}
else if("datetime".equals(format)){
if(com.pega.ibm.icu.math.BigDecimal.ZERO == com.pegarules.generated.pega_rules_string.toDateTime(answerValue)){
answer.addMessage("InvalidDateTimeValue\t" +answerValue);
}
}
}
Pegasystems Inc.
IN
Hi,
you can try using "IsValidDate" validate rule in an activity under the "Property-Validate" method and it seems to be working.
Accepted Solution
John Deere
IN
Hi ,
I was able to pass the date from DT to when rule and was able to validate the date using @DateTime.CompareDate() function.