CSVHelper FormatException with DateTime

Question

The issue I have is with the CSVHelper library in particular. My csv file looks something like this: ``` 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] ``` What I am doing with CSVHelper is this: ``` List result = new List(); using (TextReader fileReader = File.OpenText("data.csv")) { var csv = new CsvReader(fileReader); result = csv.GetRecords().ToList(); } ``` The issue is that when It tries to execute GetRecord on the last line, I get this exception: ``` 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(TypeConverterOption…

Accepted Answer

My guess is that your default culture specifies a different date format than what is in the CSV file. Try setting the culture to one that matches the data.

```
    var csv = new CsvReader(fileReader);
    csv.Configuration.CultureInfo = CultureInfo.GetCultureInfo("en-GB");
    result = csv.GetRecords<Transaction>().ToList();
```

Fiddle: https://dotnetfiddle.net/iTvc4Y

CSVHelper FormatException with DateTime

Solution

Problem