Dear Nathan:
You do not use a "criterion" to perform ordering. Criteria are for
filtering. Just a small technical detail, but it's good to keep your
references accurate so you are better understood when you discuss things
here.
The "format" of the date does not matter. Perhaps this is another of those
technical details. A format determines how a values is displayed, but not
how it is stored. Hopefully, your date is stored as a date/time datatype.
If not, then you are probably storing it as a string. If you are storing it
as a string, then you cannot index it to have the order you want, but you
can still sort it that way. However, without an index, a sort will require
considerable effort on the "front end" every time rows from your table are
sorted in this manner.
Assuming you have the date stored as a date/time datatype, you can simply
choose to order by this column. The database engine will already know how
to do so.
If the value is entered as a string, you will need to sort by another value
you derive from this string. If you manipulate the string so it is yyyymmdd
then you could accurately sort by it. Using the MID function, this would
be:
ORDER BY MID(YourDate, 7, 4) & MID(YourDate(4, 2) & MID(YourDate(1, 2)
