How to convert Mar 22, 2022 to 22-03-2022

Dear forum,
How can i convert Mar 22, 2022 to 22-03-2022?

Hi @Jayesh_Rathi1

Cdate(“Mar 22, 2022”).Tostring(“dd-MM-yyyy”)

Regards
Gokul

1 Like

Have a look on the Output @Jayesh_Rathi1

image

Regards
Gokul

@Jayesh_Rathi1

Check this one

DateTime.ParseExact(“Mar 22, 2022”, “MMM dd, yyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“dd-MM-yyyy”)

Thanks it worked…i didnt try cdate previously as i thought it wont recognize it…my bad

thanks for the reply

Great @Jayesh_Rathi1

Happy Automation

Regards
Gokul

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