@@ -, +, @@ one day from now. and note the number of loans reported. and verify that the number of loans reported remains the same. --- C4/Circulation.pm | 5 +++-- 1 files changed, 3 insertions(+), 2 deletions(-) --- a/C4/Circulation.pm +++ a/C4/Circulation.pm @@ -2604,12 +2604,13 @@ sub GetUpcomingDueIssues { my $dbh = C4::Context->dbh; my $statement = <= 0 AND days_until_due <= ? +AND (DATE( date_due )-DATE( NOW() )) >= 0 +AND (DATE( date_due )-DATE( NOW() )) <= ? END_SQL my @bind_parameters = ( $params->{'days_in_advance'} ); --