How to get the date in day month year from date value

Question

I am using excel uploading operation having date data. When I upload excel with date 17-Oct-2012 and I am getting 41199.

There may be lots of threads available in SO regarding DataTime Formatting. How this one differ from them. Have you tried anything? — sujith karivelil, Aug 17 '16 at 06:27

score 1 · Answer 1 · edited Aug 17 '16 at 06:29

1

You need to convert the date format from OLE Automation to the .net format by using DateTime.FromOADate.

double doubleValue = double.Parse(b);
DateTime convertedDate = DateTime.FromOADate(doubleValue );

edited Aug 17 '16 at 06:29

Zaheer Ahmed

answered Aug 17 '16 at 06:28

Umut Catal

score 1 · Answer 2 · edited May 23 '17 at 10:27

1

public static DateTime FromExcelSerialDate(int serialDate){return new DateTime(1899, 12, 31).AddDays(serialDate);}

Or other ways from old issues;

edited May 23 '17 at 10:27

Community

answered Aug 17 '16 at 06:48

huse.ckr

2 Answers2