Index: openacs-4/packages/ecommerce/www/admin/orders/gift-certificates-issued.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/orders/gift-certificates-issued.tcl,v diff -u -N -r1.1 -r1.2 --- openacs-4/packages/ecommerce/www/admin/orders/gift-certificates-issued.tcl 20 Apr 2001 20:51:14 -0000 1.1 +++ openacs-4/packages/ecommerce/www/admin/orders/gift-certificates-issued.tcl 23 Jul 2001 05:56:22 -0000 1.2 @@ -75,11 +75,14 @@ " if { $view_issue_date == "last_24" } { - set issue_date_query_bit "and sysdate-g.issue_date <= 1" + #set issue_date_query_bit "and sysdate-g.issue_date <= 1" + set issue_date_query_bit [db_map last_24] } elseif { $view_issue_date == "last_week" } { - set issue_date_query_bit "and sysdate-g.issue_date <= 7" + #set issue_date_query_bit "and sysdate-g.issue_date <= 7" + set issue_date_query_bit [db_map last_week] } elseif { $view_issue_date == "last_month" } { - set issue_date_query_bit "and months_between(sysdate,g.issue_date) <= 1" + #set issue_date_query_bit "and months_between(sysdate,g.issue_date) <= 1" + set issue_date_query_bit [db_map last_month] } else { set issue_date_query_bit "" }