Convert date to dd/mm/yyyy

Help
, , ,
1

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.

image

Has anyone any ideas? Here is my workflow.

image
image802×544 16.9 KB

image
image804×678 19.4 KB

2

@Cormac

Try this.

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

Thanks that worked!

1 Like
4

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

5

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