I have a data set made up of many 3 digit values which represent dates, where the first digit is the term in a school year (Assuming there are only 6 terms in a year) and the 2nd two digits are the year: 185 = 1st semester of 1985: 185, 186, 285, 286, 385, 390, etc. I want to sort them by the last 2 digits of each number (year), then the first digit (semester): 185, 285, 385, 186, 286, 390, etc. How can I sort the data/dates to be ordered like that?
... View more