What’s the best way to index by descending date? I need to sort by cRoadName+cMilePost+dDate.

Example:

(Name)  Airport Road
(milepost)          1.234        03/30/2001
                    1.234        03/30/2000
                    1.234        03/23/1999
                    2.345        03/30/2001
                    2.345        03/30/2000
                    2.345        03/23/1999

etc.....

Thanks