Index: openacs-4/packages/invoices/lib/projects-billable.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/invoices/lib/projects-billable.tcl,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/invoices/lib/projects-billable.tcl	14 Oct 2005 06:25:03 -0000	1.3
+++ openacs-4/packages/invoices/lib/projects-billable.tcl	26 Oct 2005 06:37:57 -0000	1.4
@@ -169,4 +169,5 @@
 db_multirow -extend {project_link} projects projects_to_bill {} {
     set project_link [export_vars -base "${pm_base_url}one" {{project_item_id $project_id}}]
     set amount_open [format "%.2f" $amount_open]
+    set creation_date [lc_time_fmt $creation_date "%q %X"]
 }
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 @@
       <querytext>
 
     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,
Index: openacs-4/packages/invoices/www/projects-billable.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/invoices/www/projects-billable.adp,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/invoices/www/projects-billable.adp	17 Oct 2005 15:08:38 -0000	1.3
+++ openacs-4/packages/invoices/www/projects-billable.adp	26 Oct 2005 06:37:57 -0000	1.4
@@ -6,7 +6,7 @@
    <td>
 	<include src="/packages/invoices/lib/projects-billable-portlet" 
 		organization_id="@organization_id@" 
-		elements="checkbox project_id title amount_open" 
+		elements="checkbox project_id title amount_open creation_date" 
 		package_id="@iv_package_id@" 
 		base_url="@iv_base_url@"
 		format=""