Pivot table excel export fails for rolling 12 month calender dimension

A user might that he is trying to export to excel the content to a pivot table with the 12 months from one specific year (making for example selections for date 01/2016 - 12/2016), might end up in a weird result where the exported file contains 11 months from this year and one month from the next year (such as 02/2016 - 01/2017).

Looking at the websocket traffic it appears like the selection state is correct, but the exported Excel file is indeed incorrect, having an off-by-one error on the months.



 

This is due to that excels rounds milliseconds to the closest year if they are not shown. The "MonthEnd" function that is used in the load script return the last ms of the current month.

Note: This is shown correctly in excel using this custom date format "ÅÅÅÅ MM DD mm:ss,000" (Could possible be .000 depending on locale).