DataGrid - ORDER BY

I'm trying to do a ORDER BY on a date field in my datagrid but it's not working. I put the ORDER BY code in my command text query which is auto generated when you use the oleDbDataAdapter wizard. Is there another way to do a ORDER BY?

thanks,
eye