Regex to check for a valid date

  • 27 February 2024
  • 3 replies

Userlevel 2
Badge +8

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)$$/


/^([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 28 February 2024, 23:38

View original

3 replies

Badge +4

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

Userlevel 2
Badge +8

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

Badge +4


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.


^(0[1-9]|1[012])[- \/.](0[1-9]|[12][0-9]|3[01])[- \/.]((?:19|20)\d\d)$$



^([1-9]|1[012])[- \/.]([1-9]|[12][0-9]|3[01])[- \/.]((?:19|20)\d\d)$$




If it help please mark as resolved.