Use curdate() instead of now() in GetMemberIssuesAndFines.
Signed-off-by: Galen Charlton <[email protected]>
---
C4/Members.pm | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/C4/Members.pm b/C4/Members.pm
index 848fdd1..19cc9fa 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];
--
1.7.0
_______________________________________________
Koha-patches mailing list
[email protected]
http://lists.koha.org/mailman/listinfo/koha-patches
