Sorting date in SDE layer

I have a SDE table feeding a layer, I do like to be able to sort the date field to rank from the most recent to oldest when displayed in the map.