Index: openacs-4/packages/ecommerce/www/admin/orders/by-order-state-and-time.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/orders/by-order-state-and-time.tcl,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/ecommerce/www/admin/orders/by-order-state-and-time.tcl	20 Apr 2001 20:51:14 -0000	1.1
+++ openacs-4/packages/ecommerce/www/admin/orders/by-order-state-and-time.tcl	23 Jul 2001 05:40:41 -0000	1.2
@@ -77,11 +77,14 @@
 }
 
 if { $view_confirmed == "last_24" } {
-    set confirmed_query_bit "and sysdate-o.confirmed_date <= 1"
+    #set confirmed_query_bit "and sysdate-o.confirmed_date <= 1"
+    set confirmed_query_bit [db_map last_24]
 } elseif { $view_confirmed == "last_week" } {
-    set confirmed_query_bit "and sysdate-o.confirmed_date <= 7"
+    #set confirmed_query_bit "and sysdate-o.confirmed_date <= 7"
+    set confirmed_query_bit [db_map last_week]
 } elseif { $view_confirmed == "last_month" } {
-    set confirmed_query_bit "and months_between(sysdate,o.confirmed_date) <= 1"
+    #set confirmed_query_bit "and months_between(sysdate,o.confirmed_date) <= 1"
+    set confirmed_query_bit [db_map last_month]
 } else {
     set confirmed_query_bit ""
 }