I'm trying to sort a bunch of records by date, but it doesn't seem to be working right. All I'm doing is putting "ORDER BY Completion_Date" at the end of the SQL statement. Is there a better way to do this?
What is the result that you are getting? Does it seem to be sorting by another field? Also, is your field of datatype "Date"?
If your field is defined as date(time), that should work fine. Is it just defined as text/varchar?
The data type was text. I changed it and it seems to be working fine now. Didn't even consider that! Thanks!