X-Git-Url: http://koha-dev.rot13.org:8081/gitweb/?a=blobdiff_plain;f=C4%2FSQLHelper.pm;h=b8670942c50478651f63b018c1d9320cfc964fb7;hb=684143a529cb556236f46d1d2a8ef05908c0b2f9;hp=21f5fa179b0799f05f3fe6f8cea79e1f80897d0e;hpb=8a53d284907bbbe9d3ee2552e964af9f5dfbd0ac;p=koha_fer

diff --git a/C4/SQLHelper.pm b/C4/SQLHelper.pm
index 21f5fa179b..b8670942c5 100644
--- a/C4/SQLHelper.pm
+++ b/C4/SQLHelper.pm
@@ -404,9 +404,15 @@ sub _filter_hash{
     my $elements=join "|",@columns_filtered;
 	foreach my $field (grep {/\b($elements)\b/} keys %$filter_input){
 		## supposed to be a hash of simple values, hashes of arrays could be implemented
-		$filter_input->{$field}=format_date_in_iso($filter_input->{$field})
-          if $columns->{$field}{Type}=~/date/ &&
-             $filter_input->{$field} !~C4::Dates->regexp("iso");
+        if ( $columns->{$field}{Type}=~/date/ ) {
+            if ( defined $filter_input->{$field} ) {
+                if ( $filter_input->{$field} eq q{} ) {
+                    $filter_input->{$field} = undef;
+                } elsif ( $filter_input->{$field} !~ C4::Dates->regexp("iso") ) {
+                    $filter_input->{$field} = format_date_in_iso($filter_input->{$field});
+                }
+            }
+        }
 		my ($tmpkeys, $localvalues)=_Process_Operands($filter_input->{$field},"$tablename.$field",$searchtype,$columns);
 		if (@$tmpkeys){
 			push @values, @$localvalues;