I use reports that contain tables (e.g. the milestones report) and I want to sort the rows into ascending date order. However, there are always a small number of rows that are out of sequence. I’m using the Sort By in the Field List dialogue box correctly, I have even tried changing the display format, but still can’t get it to sort accurately. I have found some comments, > a year old, on the Microsoft Community, but no resolution seems to have been found. https://answers.microsoft.com/en-us/msoffice/forum/all/ms-project-reports-not-sorting-correctly-by-date/b880e417-19db-461d-862e-c41c44764211.
It doesn’t seem to be a universal problem, so wondering if anyone has found a solution? If not, how does this get raised with Microsoft to get a fix?