UiPath Wrting Excel Date Value in MM/DD/YYYY


#1

We want to write a date string eg “07/08/2018 10:00:00” to Excel but running in UiPath, it converts the value to “08/07/2018 10:00:00”. It appears UiPath using the US regional date format.

Please assist? or if you have encounter similar issue/behaviour.

Thanks,
Nelson


#2

Yes, UIpath using the US regional date format.


#3

Hey @nelson

If you want in that particular format you can use dateVariable.ToString(“dd/MM/yyyy hh:mm:ss”)


#4

Hey, @nelson.

The best way to approach this is to have a template Excel file with the column you want formated with Date (dd/MM/yyyy hh:mm:ss). In UiPath, for that column, I am assuming you have it in DateTime already so just do this:

yourDate.toString("dd/MM/yyyy hh:mm:ss")

And it will be all correct in the Excel file.