Domina chat - Regular expression for validating date format ddmmyyyy

“31/4/20100”, “31/04/2010” – April has 30 days only 8.

I haven't done anything to work towards such a regex, because it's honestly way above my knowledge of it and I wouldn't know where to start, and looking at similar answers dealing with regex validation of date formats confirms those suspicions for me.

I think it might help if you set an accurate expectation, as this regex does NOT, in fact, correctly validate leap years; e.g., there is no Feb.

29th in 2013, but this regex asserts that such is valid: regexr.com?

: Jan|Mar|Apr|May|Jun|Jul|Aug|Sep|Oct|Nov|Dec))\2))(?

In our excel file all the Last Updated Dt column’s values are in one format i.e dd-mm-yyyy except for one value which is in mm/dd/yyyy format. Now we have added a data validator step in which we refined our data according to the regular expression you can see underneath.

According to the expression only the date format with the year ranging from 1800 to 2099 is eligible to fit the criteria with the format being dd-mm-yyyy .

However, it’s a bit hard to validate the leap year , 30 or 31 days of a month, we may need basic logic as below.

“31/11/2010” – November has 30 days only [Parser] Running: E:\workspace\mkyong\Date is valid : 1/1/2010 , true Date is valid : 01/01/2020 , true Date is valid : 31/1/2010 , true Date is valid : 31/01/2020 , true Date is valid : 29/2/2008 , true Date is valid : 29/02/2008 , true Date is valid : 28/2/2009 , true Date is valid : 28/02/2009 , true Date is valid : 31/3/2010 , true Date is valid : 31/03/2010 , true Date is valid : 30/4/2010 , true Date is valid : 30/04/2010 , true Date is valid : 31/5/2010 , true Date is valid : 31/05/2010 , true Date is valid : 30/6/2010 , true Date is valid : 30/06/2010 , true Date is valid : 31/7/2010 , true Date is valid : 31/07/2010 , true Date is valid : 31/8/2010 , true Date is valid : 31/08/2010 , true Date is valid : 30/9/2010 , true Date is valid : 30/09/2010 , true Date is valid : 31/10/2010 , true Date is valid : 31/10/2010 , true Date is valid : 30/11/2010 , true Date is valid : 30/11/2010 , true Date is valid : 31/12/2010 , true Date is valid : 31/12/2010 , true Date is valid : 32/1/2010 , false Date is valid : 32/01/2020 , false Date is valid : 1/13/2010 , false Date is valid : 01/01/1820 , false Date is valid : 29/2/2007 , false Date is valid : 29/02/2007 , false Date is valid : 30/2/2008 , false Date is valid : 31/02/2008 , false Date is valid : 29/a/2008 , false Date is valid : a/02/2008 , false Date is valid : 333/2/2008 , false Date is valid : 29/02/200a , false Date is valid : 31/4/2010 , false Date is valid : 31/04/2010 , false Date is valid : 31/6/2010 , false Date is valid : 31/06/2010 , false Date is valid : 31/9/2010 , false Date is valid : 31/09/2010 , false Date is valid : 31/11/2010 , false PASSED: Valid Date Test("1/1/2010") PASSED: Valid Date Test("01/01/2020") PASSED: Valid Date Test("31/1/2010") PASSED: Valid Date Test("31/01/2020") PASSED: Valid Date Test("29/2/2008") PASSED: Valid Date Test("29/02/2008") PASSED: Valid Date Test("28/2/2009") PASSED: Valid Date Test("28/02/2009") PASSED: Valid Date Test("31/3/2010") PASSED: Valid Date Test("31/03/2010") PASSED: Valid Date Test("30/4/2010") PASSED: Valid Date Test("30/04/2010") PASSED: Valid Date Test("31/5/2010") PASSED: Valid Date Test("31/05/2010") PASSED: Valid Date Test("30/6/2010") PASSED: Valid Date Test("30/06/2010") PASSED: Valid Date Test("31/7/2010") PASSED: Valid Date Test("31/07/2010") PASSED: Valid Date Test("31/8/2010") PASSED: Valid Date Test("31/08/2010") PASSED: Valid Date Test("30/9/2010") PASSED: Valid Date Test("30/09/2010") PASSED: Valid Date Test("31/10/2010") PASSED: Valid Date Test("31/10/2010") PASSED: Valid Date Test("30/11/2010") PASSED: Valid Date Test("30/11/2010") PASSED: Valid Date Test("31/12/2010") PASSED: Valid Date Test("31/12/2010") PASSED: In Valid Date Test("32/1/2010") PASSED: In Valid Date Test("32/01/2020") PASSED: In Valid Date Test("1/13/2010") PASSED: In Valid Date Test("01/01/1820") PASSED: In Valid Date Test("29/2/2007") PASSED: In Valid Date Test("29/02/2007") PASSED: In Valid Date Test("30/2/2008") PASSED: In Valid Date Test("31/02/2008") PASSED: In Valid Date Test("29/a/2008") PASSED: In Valid Date Test("a/02/2008") PASSED: In Valid Date Test("333/2/2008") PASSED: In Valid Date Test("29/02/200a") PASSED: In Valid Date Test("31/4/2010") PASSED: In Valid Date Test("31/04/2010") PASSED: In Valid Date Test("31/6/2010") PASSED: In Valid Date Test("31/06/2010") PASSED: In Valid Date Test("31/9/2010") PASSED: In Valid Date Test("31/09/2010") PASSED: In Valid Date Test("31/11/2010") =============================================== com.mkyong.regex.

q=Regular expression for validating Date format dd/MM/yyyy&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a Hi Rameez, Checkout Patterns.aspx?

I want to check the date which must be in format : dd-mm-yyyy using regular expression. I am using Regular Expression Validator for checking the date.

“31/9/2010”, “31/09/2010” – September has 30 days only 10.

Tags: , ,