Bug 17786 - Date filter on circulation statistics not working correctly
Summary: Date filter on circulation statistics not working correctly
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Reports (show other bugs)
Version: Main
Hardware: All All
: P5 - low normal
Assignee: Galen Charlton
QA Contact: Testopia
URL:
Keywords: Academy
Depends on:
Blocks:
 
Reported: 2016-12-16 14:26 UTC by Katrin Fischer
Modified: 2017-12-28 15:03 UTC (History)
0 users

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Katrin Fischer 2016-12-16 14:26:58 UTC
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