SID-01722: Sorting on date value including dashes

Status:	Answered	TWiki version:	4.3.2	Perl version:	5.10.0
Category:	CategoryForms	Server OS:	Solaris 10	Last update:	10 years ago

We have a table populated based a form which has a text field which we populate with a date value. If we put dashes in the date: ie yyyy-mm-dd, it will not sort correctly , but without the dashes sort works correctly. Any ideas? (I've looked at other postings on dates and sorts, but our query is different in that it just refers to a sorting question - the fact that the underlying text field holds a date should not matter.

-- Kathy Nia - 2013-06-06

Discussion and Answer

The ISO date yyyy-mm-dd sorts properly in ASCII order, I use this all the time. So I am wondering why your dates don't sort properly. US format mm-dd-yyyy does not.

-- Peter Thoeny - 2013-06-06

Closing this question after more than 30 days of inactivity. Feel free to reopen if needed. Consider engaging one of the TWiki consultants if you need timely help. We invite you to get involved with the community, it is more likely you get community support if you support the open source project!

-- Peter Thoeny - 2015-12-03

If you answer a question - or someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is below the edit box.