Convert String (dd MMMM yyyy) to Datetime (MMM dd, yyyy)

brian_satijadi · October 27, 2022, 2:02pm

Hello everyone,

I have a question about converting String format to Datetime.

For example:
before (String) → "31 June 2021
After (Datetime) → Jun 31, 2021

Could you help me?

Sudharsan_Ka · October 27, 2022, 2:11pm

Checkout this

DateTime.ParseExact(String variable,"dd MMMM yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("MMM dd, yyyy")

Regards
Sudharsan

Sudharsan_Ka · October 27, 2022, 2:12pm

I think you cant make a format in date time @brian_satijadi

Regards
Sudharsan

brian_satijadi · October 27, 2022, 2:21pm

DateTime.ParseExact(“31 June 2021”,“dd MMMM yyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“MMM dd, yyyy”)

the output is contains exception, can you help me to check the code above?

brian_satijadi · October 27, 2022, 2:21pm

any idea for this case?

Sudharsan_Ka · October 27, 2022, 2:22pm

@brian_satijadi Type the date manually there and try once

Sudharsan_Ka · October 27, 2022, 2:24pm

One bitter mistake june doesn’t have 31

Regards
Sudharsan

Gokul001 · October 27, 2022, 2:34pm

Just use the simple CDate expression

CDate("30 June 2021").ToString("MMM dd, yyyy")

Regards
Gokul

brian_satijadi · October 27, 2022, 2:59pm

oh i see hahaha, i’m so sorry… oke the final result is if the date isn’t contains in a calendar year, that data cannot coverted

system · October 30, 2022, 2:59pm

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.