From 7855f1d8bd7ed60d0de019952cf318d7c3034019 Mon Sep 17 00:00:00 2001
From: Nahuel ANGELINETTI <nahuel.angelinetti@biblibre.com>
Date: Wed, 30 Dec 2009 11:40:52 +0100
Subject: [PATCH] [followup](bug #3667) fix dateexpiry filtering

this fix the dateexpiry used to filter users, now we use date specified.
---
 C4/Members.pm | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/C4/Members.pm b/C4/Members.pm
index 71eef78b3d..7c5355e6e1 100644
--- a/C4/Members.pm
+++ b/C4/Members.pm
@@ -1853,7 +1853,8 @@ sub GetBorrowersWhoHaveNotBorrowedSince {
         push @query_params,$filterbranch;
     }
     if($filterexpiry){
-        $query .= " AND dateexpiry < NOW() ";
+        $query .= " AND dateexpiry < ? ";
+        push @query_params,$filterdate;
     }
     $query.=" GROUP BY borrowers.borrowernumber";
     if ($filterdate){ 
-- 
2.39.5