C DateTime ParseExact

Question

I have a tab delimited file which is being parsed and then inserted into a database  When I run into the date column  I have trouble parsing it   The code I have is   var insert   DateTime ParseExact line i    d M yyyy h mm   CultureInfo InvariantCulture     The string in line i  is in the formats  7 7 2011 10 48   10 20 2011 6 27  The exception I get says      The DateTime represented by the string is not supported in calendar   System Globalization GregorianCalendar

User · Answer

try this   var  insert   DateTime ParseExact line i    M d yyyy h mm   CultureInfo InvariantCulture

User · Answer

Your format string is wrong  Change it to  insert   DateTime ParseExact line i    M d yyyy hh mm   CultureInfo InvariantCulture

User · Answer

That s because you have the Date in American format in line i  and UK format in the FormatString   11 20 2011 M   d yyyy   I m guessing you might need to change the FormatString to    M d yyyy h mm

User · Answer

It s probably the same problem with cultures as presented in this related SO-thread  Why can  39 t DateTime ParseExact   parse  quot 9 1 2009 quot  using  quot M d yyyy quot   You already specified the culture  so try escaping the slashes

[c#] C# DateTime.ParseExact

Examples related to c#

Examples related to parsing

Examples related to datetime