ValidationExpresion for Date format MM/DD/YYYY

[ravula2000]

What is the ValidationExpresion to validate for the date format “MM/DD/YYYY” (It should take care of Leap year also) to assign to the RegularExpressionvalidator
Please help

Thanks
Srinivas

 

[jasonsalas]

You can set the following as the value for the ValidationExpression property of a RegularExpressionValidator:

^([0-9]{1,2})[./-]+([0-9]{1,2})[./-]+([0-9]{2}|[0-9]{4})$

This allows either MM/DD/YYYY or MM-DD-YYYY

 

[crazyboybert]

The problem with this regular expression though is it only matches the pattern of digits and seperators and doesnt check wether the date is valid or not. An expression which allowed for all the possible combinations of days in months as well as leap years is horrific to even contemplate.

A better way to approach this would be to use a custom validator and have a method which validates the date as well as the pattern. This also allows you to add extra checks such as acceptable date ranges.

Rob

------------------------------------

On with the dance! let joy be unconfined;
No sleep till morn, when Youth and Pleasure meet
To chase the glowing hours with flying feet.
-Byron

------------------------------------

 

[jasonsalas]

Yeah...I forgot to mention that. For a precise RegEx, try

http://www.regexlib.com

 

[crazyboybert]

Good site jasonsalas - cheers!

And they do have a regex for validating date as well as pattern but it is a real monster.....

Rob

------------------------------------

On with the dance! let joy be unconfined;
No sleep till morn, when Youth and Pleasure meet
To chase the glowing hours with flying feet.
-Byron

------------------------------------

 

[jasonsalas]

Yeah...there's lots of good code there...a good friend of mine put the site together and if the chief contributor.