--- a/reports/catalogue_stats.pl 2013-06-23 02:37:39.000000000 +0800 +++ b/reports/catalogue_stats.pl 2013-07-18 08:51:05.996273644 +0800 @@ -449,6 +449,15 @@ @$filters[12]=~ s/\*/%/g; $strcalc .= " AND items.ccode LIKE '" . @$filters[12] ."'"; } + if (@$filters[15]){ + @$filters[15]=~ s/\*/%/g; + $strcalc .= " AND items.dateaccessioned > '" .@$filters[15] ."'"; + } + if (@$filters[16]){ + @$filters[16]=~ s/\*/%/g; + $strcalc .= " AND items.dateaccessioned < '" .@$filters[16] ."'"; + } + $strcalc .= " group by $linefield, $colfield order by $linefield,$colfield"; $debug and warn "SQL: $strcalc";