Convert date to dd/mm/yyyy

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.


Try this.

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

Thanks that worked!

1 Like

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

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