https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17786 Bug ID: 17786 Summary: Date filter on circulation statistics not working correctly Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Reports Assignee: gmcharlt@gmail.com Reporter: katrin.fischer@bsz-bw.de QA Contact: testopia@bugs.koha-community.org The 'from' 'to' date filter on the circulation statistics wizard are exclusive, but should be inclusive. Example 1: Period: check, filter from first day of month to last day of month Patron category: check Example 2: Period: check Group by: month, select month: same as above Patron category: check These numbers can be different as the first and last day of the month are excluded from the first query. My guess is that we query with between date1 and date2 without using the date() function to ensure the results are correct for the timestamp/datetime field. Verified in 3.22.10 and 16.11.0 -- You are receiving this mail because: You are watching all bug changes.