Convert to DateTime from excel using c#

Question

My date format is like dd/mm/yyyy. When i have tried to convert it to Datetime I get this error:

System.FormatException: Le DateTime représenté par la chaîne n'est pas pris en charge dans le calendrier System.Globalization.GregorianCalendar.

English error:

System.FormatException: The datetime represented by the string is not supported in the System.Globalization.GregorianCalendar calendar.

And the error source is:

devises2.date_observation = DateTime.ParseExact(elements[0],
                                           "dd/MM/yyyy",CultureInfo.InvariantCulture );

Can you help me please?

What are the contents of `elements[0]` that cause the error? — ryanyuyu, Mar 31 '16 at 13:44
I mean what is the value of `elements[0]`? What is the specific string that causes the error? — ryanyuyu, Mar 31 '16 at 13:47
The exception saw that the string that you're trying convert is not valid. Your string is not in the format "dd/MM/yyyy". — Striter Alfa, Mar 31 '16 at 13:48
If you are really with Excel DateTime, then check http://stackoverflow.com/questions/981655/how-to-represent-a-datetime-in-excel. In Short is a float and not a text. — weismat, Mar 31 '16 at 13:50
thanks a lot !you have reason because my date format is like "MM/dd/yyyy" — mypeeka, Mar 31 '16 at 13:52

score 0 · Accepted Answer · answered Mar 31 '16 at 14:04

0

In your title you mention Excel. If that is where that date value came from, try

devises2.date_observation = DateTime.FromOADate(elements[0]);

answered Mar 31 '16 at 14:04

Hans Keﬆing

1 Answers1