what is the standard practice with pulling data out of spreedsheet (xlsx) that has a date column in it. the data comes out of the field as double. i checked the help file and didnt see any thing reguarding this?
this is an ex of the line causing the issue
.Assessment_End_Date = row.Cells(4).Value, _
the object i am spining has the property as a date
You would need to convert the double to a date using the ExcelCalcValue.ExcelDateToDateTime static method.
great!! i thought i was missing something!
thanks for the quick turn around