[Koha-bugs] [Bug 17786] New: Date filter on circulation statistics not working correctly

[bugzilla-daemon at bugs.koha-community.org]

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 at gmail.com
          Reporter: katrin.fischer at bsz-bw.de
        QA Contact: testopia at 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.