Convert Date without Month name

[atarantino]

Not sure how to convert this date. 30-APR-2022. I need for it to read 04-30-2022.

[postwick (Paul)]

It’s important to understand that “04-30-2022” is a string, not a datetime. Datetimes don’t have formats. They store a datetime value. You get the value out as a string, in whatever format you want.

That said, use Datetime.ParseExact(“30-APR-2022”,“dd-MMM-yyyy”,System.Globalization.CultureInfo.InvariantCulture) to parse the string date into an actual datetime.

Then if you want to output it as 04-30-2022 you use yourDateTimeVar.ToString(“MM-dd-yyyy”)

You can, of course, put this all together in one expression:

Datetime.ParseExact(“30-APR-2022”,“dd-MMM-yyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“MM-dd-yyyy”)

[ppr (Peter Preuss)]

[atarantino]

this was perfect, thank you. I had to put it in one expression because it needed to be a string. But this was exactly what I needed. I appreciate the help.