[FIX] correct various date issues in reporting

[odoo/odoo.git] / addons / crm / report / crm_lead_report.py

diff --git a/addons/crm/report/crm_lead_report.py b/addons/crm/report/crm_lead_report.py
index 2b46be9..82c68be 100644 (file)
--- a/addons/crm/report/crm_lead_report.py
+++ b/addons/crm/report/crm_lead_report.py
@@ -91,7 +91,7 @@ class crm_lead_report(osv.osv):
                     date(c.date_open) as opening_date,
                     date(c.date_closed) as date_closed,
 
-                    date_trunc('day',c.date_last_stage_update) as date_last_stage_update,
+                    c.date_last_stage_update as date_last_stage_update,
 
                     c.user_id,
                     c.probability,
@@ -107,7 +107,7 @@ class crm_lead_report(osv.osv):
                     c.country_id,
                     c.planned_revenue,
                     c.planned_revenue*(c.probability/100) as probable_revenue,
-                    date_trunc('day',c.create_date) as create_date,
+                    c.create_date as create_date,
                     extract('epoch' from (c.date_closed-c.create_date))/(3600*24) as  delay_close,
                     abs(extract('epoch' from (c.date_deadline - c.date_closed))/(3600*24)) as  delay_expected,
                     extract('epoch' from (c.date_open-c.create_date))/(3600*24) as  delay_open