Hi,
I am reading a excel file using ExcelReader, the date field it is reading as number/decimal. How to convert the number/decimal back to DateFormat.
Please advice..
DataTable EventDetails = (from DataRow dr in SelectedRows.Rows
where dr["Event Id"].ToString() == item.ToString()
select dr).CopyToDataTable();
DateTime Sdate = (DateTime)EventDetails.Rows[0]["StartDate"];
In EventDetails Datatable -- StartDate column is retriewing date as 42174.696527777778/ 42174. How do i convert it to exact date format : 6/19/2015
Thanks
Sree
Go to the complete details ...