convert string to datetime format invalid System.Datetime

Question

I have been trying many different solutions found here but none works. I want to convert the string to the format of dd/MM/yyyy

editField["ExpiryTime"] = "5/19/2011 12:00:00 AM";
DateTime dt = DateTime.ParseExact(editField["ExpiryTime"].ToString(), "dd/MM/yyyy HH:mm:ss tt",  CultureInfo.InvariantCulture);

But I always get an error of invalid System.DateTime. Pleaes help!

Right, will edit it. But what I want to do is convert it to the format dd/MM/yyyy. SO how can I achieve this? thanks~ — coffeeak
– coffeeak, Commented Oct 17, 2013 at 8:01

Tim Schmelter · Accepted Answer · 2013-10-17 08:08:58Z

1

Use CultureInfo.InvariantCulture to avoid culture issues like invalid date separators and this format:

M/dd/yyyy hh:mm:ss tt

Uppercase M is for months, dd are the days, yyyy the four digit years. Lowercase hh are the hours in 12h format(required in combination with AM/PM), mm are the minutes, ss the seconds and tt the AM/PM designator.

string input = editField["ExpiryTime"].ToString(); // "5/19/2011 12:00:00 AM"
DateTime dt = DateTime.ParseExact(input, "M/dd/yyyy hh:mm:ss tt",  CultureInfo.InvariantCulture);

I want to convert the string to the format of dd/MM/yyyy

Then use ToString in the same way, CultureInfo.InvariantCulture forces / as date separator, without it will be replaced with your current culture's date-separator:

string result = dt.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture);

edited Oct 17, 2013 at 8:08

answered Oct 17, 2013 at 8:01

Tim Schmelter

462k79 gold badges720 silver badges981 bronze badges

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

Comments

user240141 · Accepted Answer · 2013-10-17 08:03:08Z

0

If you need it as string, then you should try this

var dt = string.Format("{0:dd/MM/yyyy}",DateTime.Now);

Note: Also check your local system date time format. If it mismatches with the used one , still you might experience the same exception..

answered Oct 17, 2013 at 8:03

user240141

Collectives™ on Stack Overflow

convert string to datetime format invalid System.Datetime

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related