Problem reading Date in .xls.

Jul 21, 2010 at 2:43 PM
Hi, I am using ExcelDataReader for reading .xlsx and .xls. In my case .xlsx is working fine and when same excel is change to .xls Date field is giving ambiguous value. In .xlsx my date field is like mm/dd/yyyy and while read it with c# code that will give mm/dd/yyyy 12:00:00 am. Same case when .xls extension that will produce ambiguous value like for 2/2/2007 it gives 40132. Please suggest any solution for that. Thanks in advance.
Nov 13, 2011 at 9:45 PM

CDate.FromOADate(40132) = 2/2/2007