ive had the same issue in the past. What I did to resolve this is add two columns and in the first column, I used = Text(Date reference, "YYYY") and the other =Text(Date Reference, "MM").
This returned the value of the year and the month in two columns. Make sure to add the headings. Then when you want to sort the columns by dates, choose year then month in the pivot table.
Hope that helps.