How to convert change language month name to english

[Raja.G (Mr.RPABot)]

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

[mkankatala (Mahesh Kankatala)]

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!!

[ppr (Peter Preuss)]

@Raja.G

21 juni 2019

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

[Raja.G (Mr.RPABot)]

Hi @mkankatala ,

Variable type is Datetime?

[mkankatala (Mahesh Kankatala)]

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!!

[rlgandu (Rajyalakshmi Gandu)]

@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