android - Sort Date column which is in MM/dd/yyyy format in sqlite -

this question has answer here:

• ordering dates descending in sqlite 1 answer

i want max date first following query not return correct data

cursor mcursor = db.rawquery("select * "                 + eservice_ticket_sync_table + " " + eservice_send_status                 + " = ? , " + eservice_user_id + " = ? order date("                 + eservice_creation_date + ") desc ", new string[] {                 send_status, user_id }); 

i had stored eservice_creation_date in format mm/dd/yyyy text.

thanks in advance.

correct usage of "order is": order column_name desc