I never used CsvHelper, but on visiting the Issues on the GitHub page I noticed an issue:
Multiple date format support · Issue #603 · JoshClose/CsvHelper · GitHub[
^]
After reading that I think for dates might you need to use something like:
TypeConverterOption("yyyyMMdd")
Updated answer:
var dFm = new DateTime(2015, 01, 25);
var dTo = new DateTime(2015, 01, 27);
using (var reader = File.OpenText(@"sample.csv"))
{
var csv = new CsvReader(reader);
while (csv.Read())
{
var date = csv.GetField<string>("Date");
var date2 = DateTime.ParseExact(date, "MM/dd/yyyy", null);
if (date2 >= dFm && date2 <= dTo)
{
Debug.Print(date2.ToLongDateString());
}
}
}