Not recognized valid date date time

Question

Need to convert 08-13-2022 10:27 PM to 08/12/2022.

This is my code:

 DateTime date = DateTime.Parse(String.Format("MM/dd/yyyy", row["POSTING_DATE"]));
 row["POSTING_DATE"] = Convert.ToDateTime(date);

But I get this error:

not recognized valid date date time

share the data you have in row["POSTING_DATE"], in 1st line. — Amit Verma, Aug 13 '22 at 02:37
Does this answer your question? [How to get the current date without the time?](https://stackoverflow.com/questions/6817266/how-to-get-the-current-date-without-the-time) — Rodney_RWR, Aug 13 '22 at 02:38
You dont need to create a string and parse it to create a DateTime variable. You can create them directly. — Ňɏssa Pøngjǣrdenlarp, Aug 13 '22 at 03:10
`Convert.ToDateTime(date)` is a bit pointless when `date` is already a `DateTime`. — Enigmativity, Aug 13 '22 at 08:08
It's also a bit pointless doing a `DateTime.Parse` on a string create using `String.Format` on a value which was a `DateTime` anyway. — Enigmativity, Aug 13 '22 at 08:09

score 2 · Answer 1 · answered Aug 13 '22 at 02:42

2

You can use the DateTime.ParseExact method as follows:

string POSTING_DATE = "08-13-2022 10:27 PM";
DateTime date = DateTime.ParseExact(POSTING_DATE, "MM-dd-yyyy hh:mm tt",  System.Globalization.CultureInfo.InvariantCulture);
POSTING_DATE = date.ToString("MM/dd/yyyy", System.Globalization.CultureInfo.InvariantCulture);
Console.WriteLine(POSTING_DATE);//prints 08/13/2022

answered Aug 13 '22 at 02:42

Nitin Sawant

7,278
9
52
98

Can you also include why the OP's code was wrong? – Enigmativity Aug 13 '22 at 08:07

Not recognized valid date date time

1 Answers1