String was not recognized as a valid DateTime

Question

1.73/5 (4 votes)

See more:

Hi,

I am getting an error of string converion to datetime.

strdate comes dynamically..for e.g: strdate11=24-06-12

C#

dtDate12 = Convert.ToDateTime(strdate11);

the above was working in my localhost; but gave error on staging site.

So, I wrote the conversion format in the folloeing way:

C#

dtDate12 = DateTime.ParseExact(strdate11, "MM/dd/yyyy HH:mm:ss", null);

and also the last attribute to CultureInfo.InvariantCulture;

But it gives me eror on my localhost itself:
String was not recognized as a valid DateTime

Please help

Thanks,
Kiran

Posted 9-Jul-12 1:57am

mahale 2010

Updated 14-Nov-12 3:13am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

v2

Add a Solution

Comments

[no name] 9-Jul-12 9:09am

Additionally, I think that you will probably find that "12" is not a valid year.

7 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

bbirajdar · Answer 1 · 2012-07-09T02:00:00

This is due to the difference in culture settings on your local machine and hosting server. You need to specify the culture in your web.config which will override the hosting server settings

http://stackoverflow.com/questions/3768061/datetime-format-different-on-local-machine-compared-to-production-machine[^]

Mits Machhi · Answer 2 · 2012-07-11T20:25:00

try This :

IFormatProvider theCultureInfo = new System.Globalization.CultureInfo("en-GB", true);
     DateTime from_date = DateTime.ParseExact(string1, "dd/MM/yyyy", theCultureInfo);
     DateTime to = DateTime.ParseExact(string2, "dd/MM/yyyy", theCultureInfo);

this will convert your string into Datetime Object.

Hope this will help you.

akee seth · Answer 3 · 2012-07-09T18:46:00

Solution 2

Try this...its working

C#

string dateString = "01-01-2012";
        DateTime date1 = new DateTime();
        date1 = DateTime.Parse(dateString, new CultureInfo("en-GB").DateTimeFormat);

Posted 9-Jul-12 18:46pm

akee seth

pradiprenushe · Answer 4 · 2012-07-09T19:10:00

Solution 4

Change this (year format change)

dtDate12 = DateTime.ParseExact(strdate11, "MM/dd/yy HH:mm:ss", null);

Posted 9-Jul-12 19:10pm

pradiprenushe

rizwan muhammed khan gouri · Answer 5 · 2012-07-11T20:23:00

Solution 5

you can also use :-

Quote:
DateTime dtEx = DateTime.Parse(str);

Posted 11-Jul-12 20:23pm

rizwan muhammed khan gouri

CafedeJamaica · Answer 6 · 2012-11-14T03:45:00

Solution 7

If the string is questionable do a try parse to test before you parse the data from the string, you should be able to reuse the original code if the try parse returns the correct value else you need to format your date string correctly.

Posted 14-Nov-12 3:45am

CafedeJamaica

chetan virkar · Answer 7 · 2012-07-09T18:56:00

Solution 3

hi
Check this[^]

try this[^]
may be this will help you.

Thank You
ChetanV

Posted 9-Jul-12 18:56pm

chetan virkar

Updated 9-Jul-12 18:57pm

v2