openerp-india team mailing list archive

[wowas <1002639@xxxxxxxxxxxxxxxxxx>]

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