Bug 41085

Summary: Date filters use the syntax stored in database.
Product: Koha Reporter: Baptiste Wojtkowski (bwoj) <baptiste.wojtkowski>
Component: REST APIAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: tomascohen
Version: Main   
Hardware: All   
OS: All   
GIT URL: Initiative type: ---
Sponsorship status: --- Crowdfunding goal: 0
Patch complexity: --- Documentation contact:
Documentation submission: Text to go in the release notes:
Version(s) released in:
Circulation function:

Description Baptiste Wojtkowski (bwoj) 2025-10-23 13:50:21 UTC
Filters used for date  in datatables are not inituitive for users since they compare date as stored in the database. 

For example, in fr, date use to be written DD/MM/YYYY, so users tend to write DD/MM in filters and find nothing. They must have written MM-DD which is barely impossible for them to guess.

Steps to reproduce :
1 - Go on a biblio record
2 - Activate filters
3 - On Date accessionned, copy/paste any field -> it will return nothing.
4 - Write the date in the format YYYY-MM-DD -> it will work

Note: I did put this in REST API but it is related to anything that calls it, if you have a better idea on where we should put this, feel free :)