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