How to convert change language month name to english

Hi Team,

I have german month name i want to change to english

if input come 21 juni 2019

i need 2019-21-06

Please anyone help me for this.

Regards,
Raja G

Hi @Raja.G

You can use the below expression,

- Assign -> Inputdate = "21 juni 2019"
- Assign -> OutputDate = DateTime.ParseExact(InputDate.toString, "dd MMMM yyyy", New System.Globalization.CultureInfo("de-DE")).toString("yy-dd-MM")

Check below workflow for better understanding,

Hope it helps!!

1 Like

Juni is at least German (english: june) so we can use the German locals for the parsing

Hi @mkankatala ,

Variable type is Datetime?

No variable type is String datatype… @Raja.G

If you want to store in DateTime variable use the below expression,

- Assign -> DateTime_Output = DateTime.ParseExact(InputDate.toString, "dd MMMM yyyy", New System.Globalization.CultureInfo("de-DE"))

Hope you understand!!

@Raja.G

Str_Date=DateTime.ParseExact("21 juni 2019", "dd MMMM yyyy", System.Globalization.CultureInfo.GetCultureInfo("de-DE")).ToString("yyyy-dd-MM")

If you want to change the Date to a specific date format then .ToString(“Your Format”) is given .If your formated date must be in Datetime type only then use this expression

DateTime_Date=DateTime.ParseExact(Str_Date, "yyyy-dd-MM", System.Globalization.CultureInfo.InvarientCulture)

Datatype:Datetime

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