title: FileHelpers will only parse datetime if date string matches universal time format
body: <p>My datetime field will only parse if the formatter is set to the universal time format and the date time is already in that format. Is this an expected behavior, or should it be able to take any proper date string and format it to a different format? If so, how does this get resolved?</p>
  
  <p>This works if the date input is already in universal format:</p>
  
  <pre><code>[FieldTrim(TrimMode.Both)]
  [FieldConverter(ConverterKind.Date, "yyyy-MM-dd hh:mm")]
  public DateTime Transaction_date; //where Transaction_date CSV value = "2019-01-02 6:00"
  </code></pre>
  
  <p>These don't work:</p>
  
  <pre><code>[FieldTrim(TrimMode.Both)]
  [FieldConverter(ConverterKind.Date, "yyyy-MM-dd hh:mm")]
  public DateTime Transaction_date; //where Transaction_date = "01-02-2019 6:00"
  </code></pre>
  
  <p>This is the exception for the above code:</p>
  
  <blockquote>
    <p>"Message": "An error has occurred.",
        "ExceptionMessage": "Error Converting '01-02-2009 06:00' to type: 'DateTime'.  Using the format: 'yyyy-MM-dd hh:mm'",
        "ExceptionType": "FileHelpers.ConvertException",
        "StackTrace": "   at FileHelpers.ConvertHelpers.DateTimeConverter.StringToField(String from)\r\n   at FileHelpers.FieldBase.AssignFromString(ExtractedInfo fieldString, LineInfo line)\r\n   at FileHelpers.FieldBase.ExtractFieldValue(LineInfo line)\r\n   at FileHelpers.RecordOperations.StringToRecord(Object record, LineInfo line, Object[] values)\r\n   at FileHelpers.FileHelperEngine<code>1.ReadStreamAsList(TextReader reader, Int32 maxRecords, DataTable dt)\r\n   at FileHelpers.FileHelperEngine</code>1.ReadStream(TextReader reader, Int32 maxRecords)\r\n   at FileHelpers.FileHelperEngine`1.ReadString(String source, Int32 maxRecords)...</p>
  </blockquote>
  
  <pre><code>[FieldTrim(TrimMode.Both)]
  [FieldConverter(ConverterKind.Date, "MM-dd-yyyy hh:mm")]
  public DateTime Transaction_date; //where Transaction_date CSV value = "2019-01-02 6:00" Note that formatter is not universal date format
  </code></pre>
  
  <p>This is the exception for the above snippet:</p>
  
  <blockquote>
    <p>"Message": "An error has occurred.",
        "ExceptionMessage": "Error Converting '2009-01-02 06:00' to type: 'DateTime'.  Using the format: 'MM-dd-yyyy hh:mm'",
        "ExceptionType": "FileHelpers.ConvertException",
        "StackTrace": "   at FileHelpers.ConvertHelpers.DateTimeConverter.StringToField(String from)\r\n   at FileHelpers.FieldBase.AssignFromString(ExtractedInfo fieldString, LineInfo line)\r\n   at FileHelpers.FieldBase.ExtractFieldValue(LineInfo line)\r\n   at FileHelpers.RecordOperations.StringToRecord(Object record, LineInfo line, Object[] values)\r\n   at FileHelpers.FileHelperEngine<code>1.ReadStreamAsList(TextReader reader, Int32 maxRecords, DataTable dt)\r\n   at FileHelpers.FileHelperEngine</code>1.ReadStream(TextReader reader, Int32 maxRecords)\r\n   at FileHelpers.FileHelperEngine`1.ReadString(String source, Int32 maxRecords)...</p>
  </blockquote>