Convert string date to another string format date

[shrishti.diggikar]

date_str_1 = 1/19/2023
date_str_2 = Jan 19, 2023

I want to convert date_str_1 (m/d/yyyy format) to date_str_2 (MMM d, yyyy) format.

Please advise. Thanks

[Anil_G (Anil Gorthi)]

@shrishti.diggikar

You can use this

DateTime.ParseExact(Date1,"M/d/yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("MMMd, yyyy")

Cheers

[supermanPunch (Arpan)]

@shrishti.diggikar

1/19/2023

Hi @shrishti.diggikar ,

Could also check with the below Expression :

CDate("1/19/2023").ToString("MMM dd, yyyy")

[mkankatala (Mahesh Kankatala)]

Hi @shrishti.diggikar

- Assign -> date_str_2 = DateTime.ParseExact(date_str_1,"M/dd/yyyy", System.globalization.CultureInfo.InvariantCulture).toString("MMM d, yyyy")

Check the below workflow for better understanding,
2024.xaml (18.1 KB)

Hope it helps!!

[Nawazish_Ahmad]

Hi @shrishti.diggikar

Use below expression in Assign Activity

date_str_1 = 1/19/2023

DateTime.ParseExact(date_str_1,“M/d/yyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“MMMd, yyyy”)

Output =Jan 19, 2023

Hope it will helps you
Cheers!!

[rlgandu (Rajyalakshmi Gandu)]

@shrishti.diggikar

Assign date_str_1 = "1/19/2023"
Assign date_obj = DateTime.ParseExact(date_str_1, "M/d/yyyy", CultureInfo.InvariantCulture).ToString("MMM d, yyyy")

[vidyasreeb (SVR)]

DateTime.ParseExact(datevariable,“M/d/yyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“MMM d, yyyy”)