My company just upgraded to 2013 so I'm upgrading all reports and sorting out compatibility issues etc...
One issue I have established is in date formatting. To get stuff sumarised by month in 2010 I had a worker column which was
=DATE(YEAR(InvoiceDate),Month(InvoiceDate),1)
and then displayed this as "MMM YYYY". This way it grouped all the data to one date (the first of the month) and displayed it in the desired format. But on graphs/charts etc 2013 seems determined to not follow this format when the data is returned to excel for use in charts/pivot tables.
Any ideas?
One issue I have established is in date formatting. To get stuff sumarised by month in 2010 I had a worker column which was
=DATE(YEAR(InvoiceDate),Month(InvoiceDate),1)
and then displayed this as "MMM YYYY". This way it grouped all the data to one date (the first of the month) and displayed it in the desired format. But on graphs/charts etc 2013 seems determined to not follow this format when the data is returned to excel for use in charts/pivot tables.
Any ideas?