Converting XLS to CSV (pipedelimited) not keeping exact date format

Help Studio
, ,
5

@jwetherin

Can you try below sample?

The image depicts an automation workflow where an Excel file is read, a range of data from a specified sheet is extracted, and the data is then written to a CSV file. (Captioned by AI)
The image depicts an automation workflow where an Excel file is read, a range of data from a specified sheet is extracted, and the data is then written to a CSV file. (Captioned by AI)585×980 26 KB

This image depicts an UiPath workflow configuration where an Excel file named "Input.xls" is read with the "Read formatting" option set to "Display value" and the resulting data is saved to a variable called "dt". (Captioned by AI)
This image depicts an UiPath workflow configuration where an Excel file named "Input.xls" is read with the "Read formatting" option set to "Display value" and the resulting data is saved to a variable called "dt". (Captioned by AI)1296×609 36.9 KB

An automation workflow is set up to read data from an Excel sheet and write it to a CSV file using a pipe delimiter, with headers included. (Captioned by AI)
An automation workflow is set up to read data from an Excel sheet and write it to a CSV file using a pipe delimiter, with headers included. (Captioned by AI)1270×613 35.4 KB

Regards,