Change String Date into another String Date

[marquezd]

Hi everyone,

I have a string date in the next format : 1-sep-2023 or 27-nov-2023 there are a few examples.

But, I wanna change this format into another string format date “dd.MM.yyyy”.

Any suggestions??

[Yoichi]

Hi,

Can you try the following expression?

 DateTime.ParseExact(yourString,"d-MMM-yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("dd.MM.yyyy")

Regards,

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @marquezd ,
You can try
Cdate(YourString).Tostring(“dd.MM.yyyy”)
regards,

[marquezd]

Tnks you guys it works with both solutions

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Cheer @marquezd ,
Happy automation!