0022022: The reports does not convert the date, time and datetime columns to the timezone of the client where they are executed

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0022022

Openbravo ERP

A. Platform

public

2012-10-22 11:08

2012-10-22 18:05

Reporter

egoitz

Assigned To

AugustoMauch

Priority

urgent

Severity

major

Reproducibility

always

Status

new

Resolution

open

Platform

OS Version

Product Version

3.0MP16

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0022022: The reports does not convert the date, time and datetime columns to the timezone of the client where they are executed

Description

The reports does not convert the date, time and datetime columns to the timezone of the client where they are executed.
When saving data on the application, the date is saved with converted to the timezone of the server. This date is converted to the timezone of the client when accessing to the data on the application.
The problems is that if you execute a report, the date of the reports is not converted.
This is not consistent because the date on the application on a timezone different than the timezone of the server is different than the date on the report

Steps To Reproduce

-Use the application on a client with a different timezone than the timezone of the server.
-See when saving a date field, that the date saved is converted to the timezone of the server.
-On the application you see the date converted to your timezone.
-Execute a report that get this date column.
*See that the date is not converted, so the report shown a date different that what you see on the application.

Proposed Solution

Additional Information