https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31331 Bug ID: 31331 Summary: OPAC suggestions table doesn't sort correctly by suggeestiondate in some dateformats Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: OPAC Assignee: oleonard@myacpl.org Reporter: lucas@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org To recreate: 1. I used the following suggestiondates: MariaDB [koha_kohadev]> select suggesteddate from suggestions; +---------------+ | suggesteddate | +---------------+ | 2022-01-03 | | 2022-08-09 | | 2022-02-22 | | 2021-01-21 | +---------------+ 2. Set the dateformat system preference to 'mm/dd/yyyy'. 3. Try sorting the suggestion table bu date, ascending and descending, it is not right. -- You are receiving this mail because: You are watching all bug changes.