Table has a "Date" column and we are sorting by that date. The dates don't seem to be sorting exactly by date.
What are the rules for sorting by date? Do the dates have to be in a very specific format? Do they, for instance have to be xx/xx/xxx?
If there is 1/5/2013 does it need to be 01/05/2013 in order to sort?