From f4a7c72d7f40336dbc325c4cf95674c3580a5c42 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 43305c5cbd..7644c36132 100644
--- a/C4/Members.pm
+++ b/C4/Members.pm
@@ -1885,7 +1885,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.20.1