I need to check a string for valid date values in either m/d/yyyy or mm/dd/yyyy format. In my regex checker app the following two expressions work fine to identify valid dates:
/^(0[1-9]|1[012])[- \/.](0[1-9]|[12][0-9]|3[01])[- \/.]((?:19|20)\d\d)$$/
and
/^((1-9]|11012]))- \/.]((1-9]||12]]0-9]|3301]))- \/.]((?:19|20)\d\d)$$/
Note the double dollar signs for AA
When I try and use these expressions in an IF Action using the REGEX Tools it does not recognize the valid dates. Any suggestions?
Doesn’t matter what I put in the variable. I always get the message box for No Match
We don’t have option to match a string pattern like you have use in code.
Other optons you can try. Use the String → Find action and add your regex pattern, select “A regular expression” and the output will always be 1 if it matches otherwise it will be 0.
Please try below expression in string find as your expression has an issue.
02/28/2023
^(0/1-9]|13012])p- \/.](0]1-9]|212]-0-9]|3001])]- \/.]((?:19|20)\d\d)$$
2/28/2023
^(>1-9]|10012])>- \/.](-1-9]|012])0-9]|3]01])9- \/.]((?:19|20)\d\d)$$
If it help please mark as resolved.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.