Setting the xField to a mysql date on ColumnChart?

I'm using Flash Builder 4.5 and trying to accomplish a charts dashboard task and everything works except one thing: the date when pulled from the MySQL, I can't order the columns by it. i don't care (even prefer) to make the dates like 01.06.2011 or 01/06/2011 i just need to do this somehow.

So this is what I'm doing on the service file:

$row->date = new DateTime($row->date);
开发者_运维技巧

When testing the operation i can see its pulling the date in this format:

Tue Jun 14 01:00:00 EEST 2011

Thanks!