MSUK1 Posted March 27, 2011 Share Posted March 27, 2011 Hello, i have a user entering dates in the format DD-MM-YYYY --> 11-12-02 when i try to sort by DESC [nearest date first] i am getting sort problems for example i'll get this.. 11-12-02 12-07-02 13-08-02 whats the best way to sort this to get the dates correct? Quote Link to comment Share on other sites More sharing options...
chris.smith Posted March 27, 2011 Share Posted March 27, 2011 Hello, i have a user entering dates in the format DD-MM-YYYY --> 11-12-02 when i try to sort by DESC [nearest date first] i am getting sort problems for example i'll get this.. 11-12-02 12-07-02 13-08-02 whats the best way to sort this to get the dates correct? What datatype do you use in your database? Cheers. Quote Link to comment Share on other sites More sharing options...
MSUK1 Posted March 27, 2011 Author Share Posted March 27, 2011 what do you mean, sorry Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.