Convert string to datetime issue

Question

I'm trying to convert a date string in one format into another. However, I get this exception error message

String was not recognized as a valid DateTime.

My code is as follows:

string theDate = "28-Feb-13 4:00:00 PM";

DateTime tempDate = DateTime.ParseExact(theDate, "dd-MMM-yy hh:mm:ss tt", CultureInfo.InvariantCulture, DateTimeStyles.None);

convertedDate = tempDate.ToString("yyyy/MM/dd hh:mm:ss");

I seriously have no idea what went wrong.

I think your issue is string to datetime and not the other way around as in the title — Techmonk
– Techmonk, Commented Feb 15, 2013 at 7:36

Farhad Jabiyev · Accepted Answer · 2014-04-06 05:57:52Z

13

You must change

28-Feb-13 4:00:00 PM to 28-Feb-13 04:00:00 PM

or

dd-MMM-yy hh:mm:ss tt to dd-MMM-yy h:mm:ss tt

edited Apr 6, 2014 at 5:57

answered Feb 15, 2013 at 7:30

Farhad Jabiyev

26.9k8 gold badges79 silver badges103 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

SWeko Over a year ago

When DateTime says ParseExact, it means it.

ixora Over a year ago

So that was what it was all about! And here I thought that the computer is smart enough to detect that. Thank you for your help. I really appreciate it after I've been staring at the code for some time

ixora Over a year ago

@SWeko : I should have suspected that it took the word 'Exact' seriously :D

SWeko Over a year ago

@ixora DateTime.Parse is the smart one that tries to figure out what kind of date string you have, tries to help out, and often goes horribly wrong. Using ParseExact is telling the compiler "I know my data better than you. Work like this and do not try to second guess me".

Nolonar Over a year ago

@ixora No, convertedDate is correct and follows the specified format. If you think it's wrong, that's because the format specified is wrong. See here how to define the correct format: msdn.microsoft.com/en-us/library/8kb3ddd4.aspx Or maybe you're referring to yyyy/MM... being output as yyyy-MM...?

|

Collectives™ on Stack Overflow

Convert string to datetime issue

1 Answer 1

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related