title: CSVHelper FormatException with DateTime
body: <p>The issue I have is with the CSVHelper library in particular.</p>
  
  <p>My csv file looks something like this:</p>
  
  <pre><code>Number,Date,Account,Amount,Subcategory,Memo
   ,09/05/2017,XXX XXXXXX,-29.00,FT , [Sample string]
   ,09/05/2017,XXX XXXXXX,-20.00,FT ,[Sample string]
   ,08/05/2017,XXX XXXXXX,-6.30,PAYMENT,[Sample string]
  </code></pre>
  
  <p>What I am doing with CSVHelper is this:</p>
  
  <pre><code>        List&lt;Transaction&gt; result = new List&lt;Transaction&gt;();
          using (TextReader fileReader = File.OpenText("data.csv"))
          {
              var csv = new CsvReader(fileReader);
              result = csv.GetRecords&lt;Transaction&gt;().ToList();
          }
  </code></pre>
  
  <p>The issue is that when It tries to execute GetRecord on the last line, I get this exception:</p>
  
  <pre><code>Unhandled Exception: System.FormatException: String was not recognized as a valid DateTime.
     at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
     at System.DateTime.Parse(String s, IFormatProvider provider, DateTimeStyles styles)
     at CsvHelper.TypeConversion.DateTimeConverter.ConvertFromString(TypeConverterOptions options, String text)
     at lambda_method(Closure )
     at CsvHelper.CsvReader.CreateRecord[T]()
     at CsvHelper.CsvReader.&lt;GetRecords&gt;d__65`1.MoveNext()
     at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
     at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
  </code></pre>
  
  <p>As you can see the data has some issues - the first column is either empty or has the string null. Even then, the exception message points to a problem with the Date which is the second column.</p>
  
  <p>Any help would be appreciated.</p>