Depending on whether you're using MD or Tabular, there is a sort order or order by column property. Use this to control the sort order and make another attribute for this. It should be yyyymmdd. You may already have a column like Date Key that can be used. This must be 1:1 with the column to be sorted though.