Exporting analytic chart with dates RRS feed

  • Question

  • 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

    Tuesday, May 27, 2014 5:47 AM