FileHelperEngine CSV Datetime Comparison Error

David Smith

I am getting an datatime error conversion when I load the csv file through filehelperengine. Could someone help me. Review screen shot below. The format in my csv file 12/5/2015

[FieldOptional]
[FieldNullValue(typeof(DateTime), "1/01/1000 00:00:00")]
private DateTime mperiodStart;

public DateTime periodStart
{
get { return mperiodStart; }
set { mperiodStart = value; }
}

[FieldOptional]
[FieldNullValue(typeof(DateTime), "1/01/1000 00:00:00")]
private DateTime mperiodEnd;

pianoboyCoder

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

David Smith10y ago
I get the file on the readfile line. My datetime format in the csv file 12/5/2015. I am commented the code below because the datetime format is giving me problems.

////[FieldConverter(ConverterKind.Date, "MM/d/yyyy")]
////[FieldNullValue(typeof(DateTime), "1/01/1000 00:00:00")]
//private DateTime mperiodStart;
//public DateTime periodStart
//{
// get { return mperiodStart; }
// set { mperiodStart = value; }
//}
////[FieldConverter(ConverterKind.Date, "MM/d/yyyy")]
////[FieldNullValue(typeof(DateTime), "1/01/1000 00:00:00")]
//private DateTime mperiodEnd;
//public DateTime periodEnd
//{
// get { return mperiodEnd; }
// set { mperiodEnd = value; }
//}

0
David Smith10y ago
Thatd the exact error
0
Manas Mohapatra10y ago
Provide at which line you are getting error and what is the error exactly.
0