That sounds odd. If you add a group, it should pull the max or min date for each grouping, regardless of the sort order