Skip to main content
Answer

Regex to check for a valid date

  • February 27, 2024
  • 3 replies
  • 843 views
J
Forum|alt.badge.img+9

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

@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.

3 replies

R
Forum|alt.badge.img+4
  • r.singh
  • Navigator | Tier 3
  • February 28, 2024

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

J
Forum|alt.badge.img+9
  • JMarino
  • Author
  • Flight Specialist | Tier 4
  • February 28, 2024

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

R
Forum|alt.badge.img+4
  • r.singh
  • Navigator | Tier 3
  • Answer
  • February 28, 2024

@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.

Terms & ConditionsCookie settingsAccessibility statement