Excel to CSV. Date format not the same

excel
csv
activities

#1

Hello, I’m running into a problem when I’m taking data from an excel sheet, reading the selected range, assigning to data table variable in the output, and then writing CSV file with the previously mentioned assigned data table from read activity.

My problem is that when I write the CSV file, two columns (out of 8 total) with specific dates write those same dates in the format MM/dd/YYYY 00:00:00. I need this file in a CSV with the two date columns not featuring the time.

Is it possible to just transfer the dates over in a specific format/a format that doesn’t include the time.

I’ve tried formatting in the excel sheet before reading the range, but that doesn’t work.


#2

Download parsedate.xaml