Validating date

Validating date

In this example, employees will fill in a Vacation Request Form for the year 2017.In cell C4, the employee will enter a starting date for the vacation.The function example is comparing a string to a known date format.I suggest reading the documentation on the date format to see why you're making the wrong assumption. “31/9/2010”, “31/09/2010” – September has 30 days only 10. “31/6/2010”, “31/06/2010” -June has 30 days only 9.

“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.

In this video, three different methods are used to validate dates.

From the Allow drop down in the data validation settings, the following options will be used: Written instructions, and the sample file, are below the video.

It also intelligently checks that the date ranges are valid, so something like 02/30/2005 is caught.

@whitej71 In the example you gave, it is correctly returning false.

validating date-35validating date-48validating date-14

The below suggested date validation (from another note) does NOT work for ALL formats and date inputs.function validate Date($date, $format = 'Y-m-d H:i:s')A couple of examples should suffice as a warning to test carefully and particularly not to use code that allows passing in of just any date format string:var_dump(validate Date('7/01/16', 'n/j/y')); # false but should be truevar_dump(validate Date('7/1/16', 'm/d/y')); # false but should be true Sorry, I don't have a suggested correction.

Join our conversation (65 Comments).
Click Here To Leave Your Comment Validating date.

Comments:

Leave a Reply

Your email address will not be published. Required fields are marked *