Date validation

[Samuel Shulman]

Hi

What is the simplest way to validate date input (best if I can use the
ASP.NET validation control)

Thank you,
Samuel

 

[Mark Rae]

What is the simplest way to validate date input (best if I can use the
ASP.NET validation control)

I have my own JavaScript routines for this - what sort of validation are you
looking for...?

 

[Arundhati Anavekar]

use the CompareValidator and set the 'Type' property to 'date'

example:

<asp:CompareValidator id="cvDate" runat="server"
ErrorMessage="Invalid Date inserted" ControlToValidate="Control1"
Operator="DataTypeCheck" Type="Date"></asp:CompareValidator>
<asp:Button id="Button1" runat="server" Text="Test it"></asp:Button>


thanks,
aru

 

[Kevin Spencer]

If you want to validate using a regular expression, this will work for
virtually all SQL Server date formats:

(?m)(?i)(?<DateValue>(?:\d{1,4}[-\.-/]\d{1,2}[-\.-/]\d{1,4}|\d{1,2}\s{1,}\w{3,}\s{1,}\d{2,4}|\w{3,}\s{1,}\d{1,2}\s{1,}\d{2,4})(?:\s{1,}\d{1,2}:*\d{1,2}:*\d{1,2}(?:\.*\d*)?\s*(?:A\.?M|P\.?M\.?)?)?)

This includes such format variations as:

2/1/2007
02/01/07
feb 1 2007
1 Feb 2007
2007-02-01
2/1/2007 6:00 PM
2.1.2007
02/01/07 6:00 P.M.
feb 1 2007 18.00.00
1 Feb 2007 18:00:00.666
2007-02-01 06:00:00 PM
2.1.2007 18:00

--
HTH,

Kevin Spencer
Microsoft MVP
Software Composer
http://unclechutney.blogspot.com

The shortest distance between 2 points is a curve.

 

[Samuel]

Thank you all

If you want to validate using a regular expression, this will work for
virtually all SQL Server date formats:

(?m)(?i)(?<DateValue>(?:\d{1,4}[-\.-/]\d{1,2}[-\.-/]\d{1,4}|\d{1,2}\s{1,}\w{3,}\s{1,}\d{2,4}|\w{3,}\s{1,}\d{1,2}\s{1,}\d{2,4})(?:\s{1,}\d{1,2}:*\d{1,2}:*\d{1,2}(?:\.*\d*)?\s*(?:A\.?M|P\.?M\.?)?)?)

This includes such format variations as:

2/1/2007
02/01/07
feb 1 2007
1 Feb 2007
2007-02-01
2/1/2007 6:00 PM
2.1.2007
02/01/07 6:00 P.M.
feb 1 2007 18.00.00
1 Feb 2007 18:00:00.666
2007-02-01 06:00:00 PM
2.1.2007 18:00

--
HTH,

Kevin Spencer
Microsoft MVP
Software Composer
http://unclechutney.blogspot.com

The shortest distance between 2 points is a curve.

Hi

What is the simplest way to validate date input (best if I can use the
ASP.NET validation control)

Thank you,
Samuel

 

[Cowboy \(Gregory A. Beamer\)]

On the server side, you can try DateTime.TryParse:
http://msdn2.microsoft.com/en-us/library/ch92fbc1.aspx