Index: openacs-4/contrib/packages/project-manager/www/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/index-postgresql.xql,v
diff -u -r1.5 -r1.6
--- openacs-4/contrib/packages/project-manager/www/index-postgresql.xql	26 Aug 2003 00:05:58 -0000	1.5
+++ openacs-4/contrib/packages/project-manager/www/index-postgresql.xql	29 Aug 2003 00:35:35 -0000	1.6
@@ -15,11 +15,11 @@
 	to_char(p.planned_start_date, 'Mon DD ''YY') as planned_start_date,
 	to_char(p.planned_end_date, 'Mon DD ''YY') as planned_end_date,
 	p.ongoing_p,
-        p.estimated_completion_date - p.planned_end_date as days_late,
-        p.earliest_completion_date  - p.planned_end_date as days_late_earliest,
-        p.latest_completion_date    - p.planned_end_date as days_late_latest,
         p.actual_hours_completed,
-        p.estimated_hours_total
+        p.estimated_hours_total,
+        to_char(p.estimated_finish_date, 'Mon DD ''YY') as estimated_finish_date,
+        to_char(p.earliest_finish_date, 'Mon DD ''YY') as earliest_finish_date,
+        to_char(p.latest_finish_date, 'Mon DD ''YY') as latest_finish_date
         FROM pm_projectsx p, cr_items i
         WHERE p.project_id = i.live_revision
         ORDER BY i.tree_sortkey