From b91f6ced43e963cea38da54ad1c3502143fe62c2 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Mon, 16 Oct 2017 11:59:10 -0300 Subject: [PATCH] Bug 13572: Patrons are still active if their expiry date is today --- misc/maintenance/borrowers-force-messaging-defaults | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/misc/maintenance/borrowers-force-messaging-defaults b/misc/maintenance/borrowers-force-messaging-defaults index d00597bfa2..079e68d195 100755 --- a/misc/maintenance/borrowers-force-messaging-defaults +++ b/misc/maintenance/borrowers-force-messaging-defaults @@ -56,7 +56,7 @@ sub force_borrower_messaging_defaults { my $sql = "SELECT borrowernumber, categorycode FROM borrowers WHERE dateenrolled >= ?"; if ($not_expired) { - $sql .= " AND dateexpiry > NOW()" + $sql .= " AND dateexpiry >= NOW()" } my $sth = $dbh->prepare($sql); $sth->execute($since); -- 2.11.0