I make report as following: web client side 1) Add code to webclient, that it send through context timezone shift from UTC (from browser view).
server side 1) Get timezone shift from context 2) Read table 3) Correct datetime with timezone shift and save it to new temporary column (datetime in local timezone for a particular user) 4) Group and filter on corrected datatime (in this point code the same, that without timezone) -- You received this bug notification because you are a member of OpenERP Indian Team, which is subscribed to OpenERP Addons. https://bugs.launchpad.net/bugs/1002639 Title: [6.1] TimeZone ERRORs in statistical reports Status in OpenERP Addons (modules): Confirmed Bug description: In All statistical reports, that use extract Date, Month and etc. from timestamp, there are an error on the border of days. For example in "crm\report\crm_lead_report.py": to_char(c.create_date, 'YYYY') as creation_year, to_char(c.create_date, 'MM') as creation_month, to_char(c.create_date, 'YYYY-MM-DD') as creation_day, don't worry about timezone and convert to year, month and day in UTC time. But if we have stored date 2012-05-31 23:00:00 and our time zone +4hours we get ERRORs from such convertions. Local time must be 2012-06-01 03:00:00 and expected day - 1 JUNE, but we get day (for this record) - 31 MAY. To manage notifications about this bug go to: https://bugs.launchpad.net/openobject-addons/+bug/1002639/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~openerp-india Post to : [email protected] Unsubscribe : https://launchpad.net/~openerp-india More help : https://help.launchpad.net/ListHelp
