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

Help Forum
,
1

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?

1 Like
2

HI @brian_satijadi

Checkout this

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

image
image948×229 17 KB

Regards
Sudharsan

1 Like
3

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

Regards
Sudharsan

4

image
image718×44 2.6 KB

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?

5

any idea for this case?

6

@brian_satijadi Type the date manually there and try once

7

@brian_satijadi

One bitter mistake :smile: june doesn’t have 31

Regards
Sudharsan

2 Likes
8

Hi @brian_satijadi

Just use the simple CDate expression

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

image

Regards
Gokul

1 Like
9

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 :+1:

10

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