Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0002421Openbravo ERPB. User interfacepublic2007-12-27 16:422008-11-26 13:57
Reporteruser11 
Assigned Tocromero 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.40alpha-r2 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0002421: AT235MP1:Problems with date formats display
DescriptionConfiguration: Ubuntu 7.10, Tomcat 5.5, 8.1.10, Openbravo 2.

Openbravo version "Openbravo ERP 2.35 MP1 --- Built on 2007-12-21 21:01:10"

1. Change the Openbravo.properties to support MM/DD date format (American date format).

2. Do ant compile && ant war && ant deploy.

3. Log in into Openbravo

4. The already existing 'sales orders' are displayed with DD/MM format instead of MM/DD. For example, the sales order 'WO /06 / 937' from client 'Big Bazzar'.

5. Create a simple sales order. The default date is correctly set to '12-27-2007'. However, if you click on the calendar control and you select December 5th the date in the field becomes '12-05-2007' and a red tooltip says 'the value entered is not valid'.

Jordi,

Note: I include my Openbravo.properties file
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0003576 closed cromero AT235MP1:Problems with date formats display 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-11-26 13:57psarobeRegression testing => No
2008-11-26 13:57psarobeStatusresolved => closed

Notes
(0006010)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:43)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1858972 [^]
(0002881)
user11   
2007-12-28 13:58   
(edited on: 2008-06-12 09:23)
Logged In: YES
user_id=1505407
Originator: YES

Regarding problem described at point 4 (sales order). I cannot longer reproduce it. I deleted the openbravo context. I do not know if it is related.

Still can reproduce the problem with the date selector.

Jordi,
(0002882)
rafaroda   
2007-12-28 21:49   
(edited on: 2008-06-12 09:23)
Logged In: YES
user_id=1892190
Originator: NO

Problem 5 is related to Javascript validations of date fields. Javascript date field validation function is not prepared for validation of MM-DD-YYYY dates.

* Additional steps
6. Enter date 01-13-2007 (13th of January of 2007): 'The value entered is not valid' message displays because Javascript function 'thinks' that it is the first day of the 13th month :|
(0002883)
iciordia   
2007-12-29 00:59   
(edited on: 2008-06-12 09:23)
Logged In: YES
user_id=1455356
Originator: NO

Currently on postgresql the database date format is "implicitly" on the function to_date (the format is hardcoded to DD-MM-YYYY. It should be read from the Openbravo.properties file. There is also a problem with dojo validation with that format.
(0002884)
user11   
2007-12-29 12:18   
(edited on: 2008-06-12 09:23)
Logged In: YES
user_id=1505407
Originator: YES

On top of fixing any possible issue it is also important that we document the current process of how to change the date and time format.

I have done so:

http://wiki.openbravo.com/wiki/index.php/Technical_FAQ_about_Openbravo_ERP#How_can_I_change_the_default_date_and_time_formats.3F [^]

Please, verify that the instructions given are correct.

Thanks,

Jordi,
(0002885)
cromero   
2008-01-02 19:13   
(edited on: 2008-06-12 09:23)
Logged In: YES
user_id=1500614
Originator: NO

Fixed in the trunk in order to admit dojo validation for US date format (MM-DD) in automatically generated windows.

Carlos Romero
Openbravo Team