Exporting analytic chart with dates

Hi,

I have an analytic chart with a list including some columns: id's names, dates, and amounts. This looks good in Sharepoint, but when I export the list to Excel, the dates are formatted as "General". They cannot be sorted or filtered as dates.

I have tried having the date both as measure and attribute, but it makes no difference, it still behaves like text when it gets over to Excel. The closest I have is having the date as an integer and format as date is Excel, but of course, this looks rubish in Sharepoint.

Any idea how I can get dates that looks and behaves like dates both in Sharepoint and the export to Excel

May 27th, 2014 8:47am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics