Index: openacs-4/packages/invoices/lib/report-month-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/invoices/lib/report-month-postgresql.xql,v diff -u -N -r1.2 -r1.3 --- openacs-4/packages/invoices/lib/report-month-postgresql.xql 7 Sep 2005 18:28:24 -0000 1.2 +++ openacs-4/packages/invoices/lib/report-month-postgresql.xql 13 Sep 2005 20:56:48 -0000 1.3 @@ -9,8 +9,7 @@ iv_invoices iv, acs_objects o where - to_char(iv.due_date, 'YYYY') = :year - and iv.recipient_id = o.object_id + iv.recipient_id = o.object_id $extra_query [template::list::filter_where_clauses -and -name iv_months] @@ -23,8 +22,7 @@ from iv_invoices where - to_char(due_date, 'YYYY') = :year - and to_char(due_date, 'MM') = :iv_month + to_char(due_date, 'MM') = :iv_month $extra_query @@ -36,8 +34,7 @@ from iv_invoices where - to_char(due_date, 'YYYY') = :year - and to_char(due_date, 'MM') = :iv_month + to_char(due_date, 'MM') = :iv_month $extra_query