#568 - Date sorting broken

Identifier #568
Issue type Minor issue (breaks specific functionality)
Title Date sorting broken
Status Completed
Handling member Chris Graham
Version 8.1
Addon General / Uncategorised
Description Catalogue date fields do not sort properly.

This is because the data in the database is stored as strings that aren't padded out.
e.g. "2012-2-3" (3rd February 2012) is not going to sort correctly compared to "2012-12-20". It should be stored padded like "2012-02-03".

This fix is not retroactive, but means new data will be stored correctly. Some other means to resolve existing data would have to be performed, such as writing some simple script, or editing each entry, or deleting the catalogue then reimporting using a CSV file.
Steps to reproduce

Funded? No
Commits

4cca140
The system will post a comment when this issue is modified (e.g., status changes). To be notified of this, click "Enable comment notifications".

Rating

Unrated