RPA(blueprism) date validation

Question

I am trying to validate date which is coming from an excel sheet , the format should be in dd/mm/yyyy i tried with regex pattern [0-9]{2}/[0-9]{2}/[0-9]{4} but this won't work with single-digit date and we since we cannot add 0 at start in excel sheet this pattern ain't working. (this is for blueprism tool which has an action for regex matching)

Answer 1

Hi, try using the regex given below it takes many date format into account as well

^(?:(?:31(\/|-|\.)(?:0?[13578]|1[02]))\1|(?:(?:29|30)(\/|-|\.)(?:0?[13-9]|1[0-2])\2))(?:(?:1[6-9]|[2-9]\d)?\d{2})$|^(?:29(\/|-|\.)0?2\3(?:(?:(?:1[6-9]|[2-9]\d)?(?:0[48]|[2468][048]|[13579][26])|(?:(?:16|[2468][048]|[3579][26])00))))$|^(?:0?[1-9]|1\d|2[0-8])(\/|-|\.)(?:(?:0?[1-9])|(?:1[0-2]))\4(?:(?:1[6-9]|[2-9]\d)?\d{2})$