From a445e956ebfec3ce932533f51c2ace19db49e1f7 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Sat, 1 May 2010 12:08:17 -0400 Subject: [PATCH] bug 4429: do not include items due today in overdue count Use curdate() instead of now() in GetMemberIssuesAndFines. Signed-off-by: Galen Charlton --- C4/Members.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/C4/Members.pm b/C4/Members.pm index 848fdd1c10..19cc9fa299 100644 --- a/C4/Members.pm +++ b/C4/Members.pm @@ -678,7 +678,7 @@ sub GetMemberIssuesAndFines { $sth = $dbh->prepare( "SELECT COUNT(*) FROM issues WHERE borrowernumber = ? - AND date_due < now()" + AND date_due < curdate()" ); $sth->execute($borrowernumber); my $overdue_count = $sth->fetchrow_arrayref->[0]; -- 2.39.5