Date format for SFDC Data Loader File in CSV
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Date Time
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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

- « Previous
-
- 1
- 2
- Next »