Here is how we can parse different date formats get validated using one function.
In VB.NET
'''Validate method for Date format
Private Function validateDate(ByVal strDate As String, ByVal strColumnName As String) As String
Dim strError As String = ""
Dim provider As CultureInfo = CultureInfo.GetCultureInfo("en-us")
Dim formatStrings As String() = {"MM/dd/yyyy", "yyyy-MM-dd", "d"}
Dim dateValue As DateTime
Try
If DateTime.TryParseExact(strDate, formatStrings, provider, DateTimeStyles.None, dateValue) Then
strError = "Success"
Else
strError = "Failed"
End If
Catch ex As Exception
End Try
Return strError
End Function
In C#
///Validate method for Date format
private string validateDate(string strDate, string strColumnName)
{
string strError = "";
CultureInfo provider = CultureInfo.GetCultureInfo("en-us");
string[] formatStrings = {
"MM/dd/yyyy",
"yyyy-MM-dd",
"d"
};
DateTime dateValue = default(DateTime);
try {
if (DateTime.TryParseExact(strDate, formatStrings, provider, DateTimeStyles.None, out dateValue)) {
strError = "Success";
} else {
strError = "Failed";
}
} catch (Exception ex) {
}
return strError;
}
Add as many as formatters to the formatStrings array and use this funtion. Happy Coding ☺☻