Regular Expression | Leap Years and More

by

As is mentioned elsewhere, regular expressions almost certanily not what you want. But, having said that, if you really want a regular expression, here is how it is built:

31 day months 

(0[13578]|1[02])[\/.](0[1-9]|[12][0-9]|3[01])[\/.](18|19|20)[0-9]{2}

30 day months

(0[469]|11)[\/.](0[1-9]|[12][0-9]|30)[\/.](18|19|20)[0-9]{2}

February 1-28 always valid

(02)[\/.](0[1-9]|1[0-9]|2[0-8])[\/.](18|19|20)[0-9]{2}

February 29 also valid on leap years

(02)[\/.]29[\/.](((18|19|20)(04|08|[2468][048]|[13579][26]))|2000)

which means it would be this if you put it all together:

((0[13578]|1[02])[\/.](0[1-9]|[12][0-9]|3[01])[\/.](18|19|20)[0-9]{2})|((0[469]|11)[\/.](0[1-9]|[12][0-9]|30)[\/.](18|19|20)[0-9]{2})|((02)[\/.](0[1-9]|1[0-9]|2[0-8])[\/.](18|19|20)[0-9]{2})|((02)[\/.]29[\/.](((18|19|20)(04|08|[2468][048]|[13579][26]))|2000))

This version is a little shorter, but a little harder to understand.

((0[13578]|1[02])[\/.]31[\/.](18|19|20)[0-9]{2})|((01|0[3-9]|1[1-2])[\/.](29|30)[\/.](18|19|20)[0-9]{2})|((0[1-9]|1[0-2])[\/.](0[1-9]|1[0-9]|2[0-8])[\/.](18|19|20)[0-9]{2})|((02)[\/.]29[\/.](((18|19|20)(04|08|[2468][048]|[13579][26]))|2000))

These scripts are long and unmaintainable. It should be clear that this isn’t a good idea, but it is possible.

Caveats:

  • range 1800-2099 (more can be added without too much difficulty, but requires changes in 4-6 disparate places)
  • requires 2 digit months and days (the strictness could be removed from the expression in ~8 places)
  • [\/.] as seperators (8 places)
  • Hasn’t been tested (we could check it against all digit combinations and compare with the javascript date function? [proof that we’re reinventing the wheel])

More Related Contents:

  1. Regex and ISO8601 formatted DateTime [duplicate]
  2. Remove text between two parenthesis, if two more parenthesis [closed]
  3. Need Pattern for password field?
  4. Detect URLs in text with JavaScript
  5. Regular Expression to get a string between parentheses in Javascript
  6. How can I convert string to datetime with format specification in JavaScript?
  7. split string only on first instance of specified character
  8. javascript regex split produces too many items
  9. Remove whitespace and line breaks between HTML elements using jQuery
  10. Remove HTML comments with Regex, in Javascript
  11. Create RegExps on the fly using string variables
  12. Regular expression for URL validation (in JavaScript)
  13. escaping question mark in regex javascript
  14. JavaScript/regex: Remove text between parentheses
  15. How to get possibly overlapping matches in a string
  16. javascript regex for password containing at least 8 characters, 1 number, 1 upper and 1 lowercase [duplicate]
  17. how to extract floating numbers from strings in javascript
  18. How do I do a Date comparison in Javascript? [duplicate]
  19. How to prevent invalid characters from being typed into input fields
  20. How to convert “camelCase” to “Camel Case”?
  21. Javascript unicode string, chinese character but no punctuation
  22. from unix timestamp to datetime
  23. What’s the correct regex range for javascript’s regexes to match all the non word characters in any script?
  24. JavaScript remove ZERO WIDTH SPACE (unicode 8203) from string
  25. Best JavaScript Date Parser & Formatter? [closed]
  26. If javascript “(new Date()).getTime()” is run from 2 different Timezones
  27. What’s different between Python and Javascript regular expressions?
  28. how to update time regularly?
  29. Regex: only alphanumeric but not if this is pure numeric
  30. Get today date in Google Apps Script

Leave a Comment