From 7855f1d8bd7ed60d0de019952cf318d7c3034019 Mon Sep 17 00:00:00 2001 From: Nahuel ANGELINETTI 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