@@ -, +, @@ - no overdue loans being reported, even if there are some that meet the criteria - overdue loans being omitted from the report if they are due on the "until" date in the filter ------- on due date, using values that should bring up one or more overdue loans. 5.5, 5.6, or 5.7 or MariaDB 5) or that loans due on the "until" date are omitted (if using MarioDB 10). set of overdue loans should be reported. --- circ/overdue.pl | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) --- a/circ/overdue.pl +++ a/circ/overdue.pl @@ -29,6 +29,7 @@ use C4::Debug; use Text::CSV_XS; use Koha::DateUtils; use DateTime; +use DateTime::Format::MySQL; my $input = new CGI; my $order = $input->param('order') || ''; @@ -321,8 +322,8 @@ if ($noreport) { $template->param(sql=>$strsth); my $sth=$dbh->prepare($strsth); $sth->execute( - ($dateduefrom ? output_pref({ dt => $dateduefrom, dateformat => 'iso' }) : ()), - ($datedueto ? output_pref({ dt => $datedueto, dateformat => 'iso' }) : ()), + ($dateduefrom ? DateTime::Format::MySQL->format_datetime($dateduefrom) : ()), + ($datedueto ? DateTime::Format::MySQL->format_datetime($datedueto) : ()), ); my @overduedata; --