I haven't had a problem with this before.
in the select you arent rewriting the column for output e.g.
if you are rename the output column, and order by the data columnCode:date_format(mix_date, '%m/%e/%Y') as mix_date
could you send me your whole query? so that I can cast an eye over it?
- Joel