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.4 -r1.5
--- openacs-4/contrib/packages/project-manager/www/index-postgresql.xql	22 Aug 2003 21:06:10 -0000	1.4
+++ openacs-4/contrib/packages/project-manager/www/index-postgresql.xql	26 Aug 2003 00:05:58 -0000	1.5
@@ -12,14 +12,14 @@
 	p.object_type as content_type,
 	p.title as project_name,
 	p.project_code,
-	to_char(p.planned_start_date, 'YYYY MM DD') as planned_start_date,
-	to_char(p.planned_end_date, 'YYYY MM DD') as planned_end_date,
+	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,
-        actual_hours_completed,
-        estimated_hours_total
+        p.actual_hours_completed,
+        p.estimated_hours_total
         FROM pm_projectsx p, cr_items i
         WHERE p.project_id = i.live_revision
         ORDER BY i.tree_sortkey