Index: openacs-4/packages/lab-report/www/view-lab-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lab-report/www/view-lab-postgresql.xql,v
diff -u -N -r1.3 -r1.4
--- openacs-4/packages/lab-report/www/view-lab-postgresql.xql	24 May 2006 12:30:41 -0000	1.3
+++ openacs-4/packages/lab-report/www/view-lab-postgresql.xql	24 Aug 2006 10:56:29 -0000	1.4
@@ -17,7 +17,10 @@
    <fullquery name="select_reports">
      <querytext>
        SELECT r.report_id, t.template_id, t.name,
-           t.description AS template_desc
+           t.description AS template_desc,
+           to_char(m.start_date, 'DD Month, YYYY') AS pretty_start_date,
+           to_char(m.end_date, 'DD Month, YYYY') AS pretty_end_date,
+	   current_timestamp AS now, m.start_date, m.end_date
        FROM lrc_template t
            LEFT OUTER JOIN lr_report r ON (r.template_id = t.template_id
                AND r.author_id = :author_id),