@@ -, +, @@ --- C4/Circulation.pm | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) --- a/C4/Circulation.pm +++ a/C4/Circulation.pm @@ -2426,7 +2426,8 @@ FROM issues LEFT JOIN items USING (itemnumber) LEFT OUTER JOIN branches USING (branchcode) WHERE returndate is NULL -HAVING days_until_due > 0 AND days_until_due < ? +AND (TO_DAYS( date_due )-TO_DAYS( NOW() )) > 0 +AND (TO_DAYS( date_due )-TO_DAYS( NOW() )) < ? END_SQL my @bind_parameters = ( $params->{'days_in_advance'} ); --