Convert date to dd/mm/yyyy

[Cormac (Cormac White)]

I know this question has been asked before but I can’t seem to get it to work for me.

I am reading a date from excel in dd/mm/yyyyy format but uipath seems to convert it to mm/dd/yyyy format. I tried to convert it back to dd/mm/yyyy using various ways but I always seem to get an error.

Has anyone any ideas? Here is my workflow.

[lakshman (Ganta lakshman)]

@Cormac

Try this.

        CDate(row("Start Date").Tostring).Tostring("dd/mm/yyyyy")

[Cormac (Cormac White)]

Thanks that worked!

[Palaniyappan (Palaniyappan P)]

Hi
Hope this expression would help you resolve this
Str_output = DateTime.ParseExact(row(“yourcolumnname”).ToString.SubString(0,10),”MM/dd/yyyy”,System.Globalization.CultureInfo.InvatiantCulture).ToString(“dd/MM/yyyy”)

Cheers @Cormac