I have these entries in the database that have a date field attached to them and looks something like:
March 1, 2008 March 9, 2008 March 10, 2008
When I do a find and get in oder of ASC it arranges the list as follows:
March 1, 2008 March 10, 2008 March 9, 2008
Is there a way to get it to display the list in the correct way?
March 1, 2008 March 9, 2008, March 10, 2008
Shandy Nantz wrote:
I have these entries in the database that have a date field attached to them and looks something like:
March 1, 2008 March 9, 2008 March 10, 2008
When I do a find and get in oder of ASC it arranges the list as follows:
March 1, 2008 March 10, 2008 March 9, 2008
Is there a way to get it to display the list in the correct way?
March 1, 2008 March 9, 2008, March 10, 2008
It sounds to me like you're storing those as a formatted string, not as a datetime object. If you set the table column type to :datetime and store the actual date, rather than a string, sorting with ASC should work. Then, format the date however you like in the view. Use a helper for consistent formatting if displaying the date in multiple places.