How to validate date is correct or Not in activity

User Experience
, , , ,
1

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.

2

Hi @Pavani_Regulagedda,

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

3

@Pavani_Regulagedda i was able to achieve this using formatdatetime function, if invalid date like feb 31 is given it fails