You need to sign in to do that
Don't have an account?
CSV export Issues with Date Fields
I am encountering two issues with Salesforce integration into MS EXCEL.
1. When I run a report and export it as either CSV or XLS file extentions my date fields export out as a mix of General text or Date/time and I can not work with them in EXCEL (even after resaving the files as a differently named XLS file and changing the field formats to date/time).
2. When I select csv as the export file type, the data exports out as 1 record across many columns per row instead of 1 record per row per column with comma's seperating the values.
Any Idea on how to resolve this?
thanks,
Mel
I have not had any troubles opening the csv reports in excel. I've always used the csv version in case I wanted to import the data into a database tool.
the problem isn't with opening the file its with having the date fields act like dates so I can perform math functions off of them.