What's the easiest way to validate this date format, eg, 31-JUL-2010 (and only this fmt)

Question

I would like to easily validate dates in this format and only this format. Any otehr format should be considered invalid.

Answer 1

You use DateTime.ParseExact or DateTime.TryParseExact. You pass through the exact format string.

In your case the format string would be d-MMM-yyyy (see here) and can be used as follows:

string dateString = "31-JUL-2010";
string format = "d-MMM-yyyy";
DateTime result = DateTime.ParseExact(dateString, format, CultureInfo.InvariantCulture);

Answer 2

Dim DateToTest As String = "01-Apr-1964"
Dim ResultDate As Date

Date.TryParseExact(DateToTest, "dd-MMM-yyyy", Globalization.CultureInfo.InvariantCulture, Globalization.DateTimeStyles.AllowWhiteSpaces, ResultDate)