how to create a regular expression for perticular date format

Question

1.00/5 (1 vote)

See more:

Hi,

I want to create a regular Expression for following for date format

21 Apr 2014

I Have tried some regular expressions but did not get any solution.

C#

(((((([1-9])|(0[1-9])|([0-1][0-2])))[\ ]{1}
([A-Z]{1}\b)([a-z]{2})[\ ]{1}
(([1-9])|([1-2][0-9])|(30)))|(2[\/]{1}(([1-9])|([1-2][0-9]))))[\/]{1}\d{4})

Posted 23-Apr-14 21:48pm

syedkhaleel

Add a Solution

Comments

[no name] 24-Apr-14 4:03am

i want restrict the use on selection/enter in date textbox

[no name] 24-Apr-14 5:47am

http://www.aspdotnet-suresh.com/2012/07/regular-expression-to-validate-date-in.html

5 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Peter Leow · Answer 1 · 2014-04-23T21:58:00

If you want to validate a date, regular expression can't.
You should use DateTime.TryParseExact Method[^]
See my example:

C#

using System;
using System.Globalization;

public class Program
{
    public static void Main()
    {
        string dateString = "21 Apr 2014"; // <-- Valid
        string format = "dd MMM yyyy";
        DateTime dateTime;
        if (DateTime.TryParseExact(dateString, format, CultureInfo.InvariantCulture,  DateTimeStyles.None, out dateTime))
        {
            Console.WriteLine("It is a valid date");
        }
        else
        {
            Console.WriteLine("It is NOT a valid date");
        }
    }
}

Sanket Saxena · Answer 2 · 2014-04-23T22:48:00

Solution 4

Try This:

^(((((0[1-9])|(1\d)|(2[0-8]))-((0[1-9])|(1[0-2])))|((31-((0[13578])|(1[02])))|((29|30)-((0[1,3-9])|(1[0-2])))))-((20[0-9][0-9]))|(29-02-20(([02468][048])|([13579][26]))))$

Posted 23-Apr-14 22:48pm

Sanket Saxena

Comments

phil.o 24-Apr-14 4:51am

This is not a strict DateTime validation. For example, this does not allow to validate a leap year, or more precisely it will validate a February, 29th on a non-leap year.
Again, REGULAR EXPRESSIONS ARE NOT MEANT TO VALIDATE DATETIMES!

Sanket Saxena 24-Apr-14 4:58am

right phil your option is better.

[no name] 24-Apr-14 4:52am

will this format work for 21 Apr 2014 format date

Sanket Saxena 24-Apr-14 4:58am

try phil solution it will help you.

**Dnyaneshwar**@Pune · Answer 3 · 2014-04-23T23:47:00

Solution 5

refer
http://stackoverflow.com/questions/15196451/regular-expression-to-validate-datetime-format-mm-dd-yyyy[^]
http://www.aspdotnet-suresh.com/2012/07/regular-expression-to-validate-date-in.html[^]
http://forums.asp.net/t/1352728.aspx?how+to+get+date+in+dd+mm+yyyy+using+C+net+[^]

Posted 23-Apr-14 23:47pm

Dnyaneshwar@Pune

lukeer · Answer 4 · 2014-04-23T21:52:00

Solution 1

Drop regex for this case. Use DateTime.TryParseExact()[^] instead. It's specialized to parsing dates and much more readable.

Posted 23-Apr-14 21:52pm

lukeer

Comments

[no name] 24-Apr-14 4:13am

i need to validate date text box

lukeer 24-Apr-14 6:02am

As others have mentioned, do it. To validate text input, use the method I suggested. It will tell you whether or not the input is a correct date.
But better would be to use a DateTimePicker[^] control instead of a TextBox. It's there for just that reason.

phil.o · Answer 5 · 2014-04-23T21:55:00

Just my 2 cents, but regular expressions are the worst choice when it comes to validate datetimes. They are not meant for handling datetime values, they are meant to handle strings.

Better use the DateTime.TryParse() method to validate datetimes.
This way:

C#

DateTime value;
if (DateTime.TryParse(yourStringInput, out value)) {
   // Valid DateTime
}
else {
   // Invalid DateTime
}

There are also some other methods that will allow you to handle specific culture format.
More here:
DateTime Structure[^]
Have a particular attention to TryParse() and TryParseExact() overloads.

Hope this helps. Good luck.

how to create a regular expression for perticular date format

5 solutions

Solution 3

Solution 4

Solution 5

Solution 1

Solution 2

Add your solution here

Preview 0