C# Programming
12-02-2013, 11:42 PM
I have this code
Date = Convert.ToDateTime(ds1.Tables[0].Rows[i].ItemArray[1])
in which ds1.Tables[0].Rows[1].ItemArray[1] holds 2013-11-28 10:20:30.783
But when I write this variable value Date to excel spreadsheet, I'm seeing value like this 41606.4350485301 on excel where it should be the date stored in my dataset. Why is that?
Date = Convert.ToDateTime(ds1.Tables[0].Rows[i].ItemArray[1])
in which ds1.Tables[0].Rows[1].ItemArray[1] holds 2013-11-28 10:20:30.783
But when I write this variable value Date to excel spreadsheet, I'm seeing value like this 41606.4350485301 on excel where it should be the date stored in my dataset. Why is that?