Question
BOA
IN
Last activity: 8 Apr 2025 8:50 EDT
How to validate date is correct or Not in activity
I have a requirement where we get date values in excel , i need to validate whether its correct date or not. Its not about format, its about valid data like user shouldnot give invalid dates like Feb 31 etc. How can i achieve this.
Accepted Solution
Updated: 8 Apr 2025 8:50 EDT
BOA
IN
@Pavani_Regulagedda i was able to achieve this using formatdatetime function, if invalid date like feb 31 is given it fails
Rulesstack Private Limited
IN
Use a Property of Type Date
When mapping Excel columns via, Activity, ensure the destination property in Pega is of type Date.
-
Pega tries to parse the value.
-
If it’s an invalid date, it will throw an exception or set the property to
null.
Regards,
Mohd Qizer Uddin
Accepted Solution
Updated: 8 Apr 2025 8:50 EDT
BOA
IN
@Pavani_Regulagedda i was able to achieve this using formatdatetime function, if invalid date like feb 31 is given it fails