I have a very odd issue with date formatting in UiPath
I have a simple workflow that downloads a CSV file from online then saves that as an excel file and outputs the results in a data-table.
When reading the rows in the data-table, a date column sometimes comes out as ‘dd/mm/yyyy’ and other times as ‘mm/dd/yyyy’. I have 4 csv files and some of them have one format and others other format, even though on excel the dates look identical (dd/mm/yyyy) format. Has anyone faced this?
Also suggestions of a solution?