Index: openacs-4/packages/invoices/lib/projects-billable.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/invoices/lib/projects-billable.xql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/invoices/lib/projects-billable.xql 5 Oct 2005 12:08:24 -0000 1.2 +++ openacs-4/packages/invoices/lib/projects-billable.xql 26 Oct 2005 06:37:57 -0000 1.3 @@ -5,7 +5,7 @@ select r.item_id as project_id, r.title, r.description, sub.amount_open, - to_char(sub.creation_date, :timestamp_format) as creation_date, total.count_total, billed.count_billed, name + sub.creation_date, total.count_total, billed.count_billed, name from ( select oi.item_id as offer_id, pr.revision_id, o.creation_date, sum(ofi.item_units * ofi.price_per_unit * (1-(ofi.rebate/100))) as amount_open,