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]|1[012])[- \/.]([1-9]|[12][0-9]|3[01])[- \/.]((?: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?
Best answer by r.singh
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]|1[012])[- \/.](0[1-9]|[12][0-9]|3[01])[- \/.]((?:19|20)\d\d)$$
2/28/2023
^([1-9]|1[012])[- \/.]([1-9]|[12][0-9]|3[01])[- \/.]((?:19|20)\d\d)$$
If it help please mark as resolved.
+4We 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]|1[012])[- \/.](0[1-9]|[12][0-9]|3[01])[- \/.]((?:19|20)\d\d)$$
2/28/2023
^([1-9]|1[012])[- \/.]([1-9]|[12][0-9]|3[01])[- \/.]((?: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.
