Regex to check for a valid date

Forum|Forum|2 years ago
February 27, 2024
3 replies
981 views

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?

Developer

Best answer by r.singh

@JMarino

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.

R

r.singh

Navigator | Tier 3

@JMarino Can you share screenshot for line of code that you are using?

J

JMarinoAuthor

Flight Specialist | Tier 4

Doesn’t matter what I put in the variable. I always get the message box for No Match

R

r.singhAnswer