Date format for SFDC Data Loader File in CSV

[allwynbazil]

Team,

I am preparing the Data Loader file in the workflow to create the cases in SFDC. However, the date format will be a big challenge while exporting the data in CSV. Data Loader accepts only CSV files, and the date format should be either YYYY/MM/DD or MM/DD/YYYY. It accepts DD/MM/YYYY as well. 

The above date format will be changed to DD-MM-YYYY in csv and the data loader throws the error "Failed to Parse Date field". I am not sure how to get the dates in required format for data loader. Please help.

Regards,

Alwin

[ShankerV · Accepted solution]

Hi @allwynbazil 

Please find the answer below.

The issue is not in the Alteryx output or .CSV format

It is the problem when opening a .CSV file in Excel or Notepad.

Always I use notepad for opening .CSV files, hence I do not have any issues.

Based on the screenshot I noticed you have opened the file in Excel.

https://admin.echo360.com/hc/en-us/articles/360035034372-Formatting-Dates-for-CSV-Imports

In the same link, they have provided the solution to reformat in the excel spreadsheet.

Hope this helps!!!!!

Many thanks

Shanker V

[allwynbazil · Accepted solution]

Thanks, @ShankerV. The solution may work for others. Saving the format in xlsx and csv also didn't work for me. I changed my system settings to YYYY-MM-DD to overcome the issue.

Regards,

Alwin