[FIX] correct various date issues in reporting

[odoo/odoo.git] / addons / mrp_operations / report / mrp_workorder_analysis.py

diff --git a/addons/mrp_operations/report/mrp_workorder_analysis.py b/addons/mrp_operations/report/mrp_workorder_analysis.py
index 844ec61..37699ad 100644 (file)
--- a/addons/mrp_operations/report/mrp_workorder_analysis.py
+++ b/addons/mrp_operations/report/mrp_workorder_analysis.py
@@ -45,7 +45,7 @@ class mrp_workorder(osv.osv):
         cr.execute("""
             create or replace view mrp_workorder as (
                 select
-                    to_date(to_char(wl.date_planned, 'MM-dd-YYYY'),'MM-dd-YYYY') as date,
+                    date(wl.date_planned) as date,
                     min(wl.id) as id,
                     mp.product_id as product_id,
                     sum(wl.hour) as total_hours,