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: [email protected]
          Reporter: [email protected]
        QA Contact: [email protected]

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.
_______________________________________________
Koha-bugs mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to