[Koha-bugs] [Bug 27442] Circulation Module Report "Overdues" assumes time of 23:59:00 on upper bound of search

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27442

Andrew Fuerste-Henry <andrew at bywatersolutions.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|INVALID                     |---
             Status|RESOLVED                    |REOPENED
            Summary|Circulation Module Report   |Circulation Module Report
                   |"Overdues" does not         |"Overdues" assumes time of
                   |accurately show overdues by |23:59:00 on upper bound of
                   |date                        |search

--- Comment #4 from Andrew Fuerste-Henry <andrew at bywatersolutions.com> ---
On second thought, I think there is still a bug here.
When one sets a date range on this report, Koha appends a time onto the later
date in order to account for the fact that our date_due values include a time.
However, the time it appends is 23:59:00. That's mostly ok, since Koha
generally uses 23:59:00 as its end-of-day date_due time. However, if events
conspire such that one ends up with items due between 23:59:01 and 23:59:59,
those items will be left out of the report.

We should just make Koha append 23:59:59 instead. 
If someone wants to get fancy in a later bug, we could also add a time-picker
to the interface and let one limit the search by time.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.