Index: openacs-4/packages/assessment/www/asm-admin/admin-request.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/asm-admin/admin-request.tcl,v
diff -u -N -r1.4.2.1 -r1.4.2.2
--- openacs-4/packages/assessment/www/asm-admin/admin-request.tcl	10 Sep 2015 08:28:02 -0000	1.4.2.1
+++ openacs-4/packages/assessment/www/asm-admin/admin-request.tcl	3 Oct 2015 18:26:39 -0000	1.4.2.2
@@ -66,13 +66,13 @@
 
 if {([info exists interval] && $interval ne "") && $interval!="all"} {
     set d_interval $interval
-    set interval_query "and to_date(al.date_requested,'YYYY-MM-DD') >= to_date('$interval','YYYY-MM-DD')"
+    set interval_query "and date_trunc('day', al.date_requested) >= to_date('$interval','YYYY-MM-DD')"
     set date_query ""
 }
 
 if {([info exists date] && $date ne "")} {
     set d_date $date
-    set date_query "and to_date(al.date_requested,'YYYY-MM-DD') = to_date('$date','YYYY-MM-DD')"
+    set date_query "and date_trunc('day', al.date_requested) = to_date('$date','YYYY-MM-DD')"
     set interval_query ""
 }