Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0005290
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] B. User interfaceminorhave not tried2008-09-29 09:572009-02-10 02:30
ReporterplujanView Statuspublic 
Assigned Todbaz 
PrioritynormalResolutionsuspendedFixed in Version
StatusclosedFix in branch2.40Fixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.40SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0005290: When entering dates with dd-mm-yy format are saved as dd-mm-00yy

DescriptionOn PostgreSQL, if I enter a date in a two year format, by example 21-09-08, it is saved on database as 21-09-0008.
Steps To Reproduce1. Go Sales Order and create a new one.
2. On Order Date field enter 21-09-08
3. Note that no AJAX warning is shown.
4. Save
5. The Order is saved, but date changed to 21-09-0008
Proposed Solution*2-digit year dates should be managed using a 100 year range. By example, dates between 1920 and 2019 are interpreted correctly when written in 2-digit format

*Display a proper warning message like "This date is probably wrong" for strange dates like year before 1900 or dates 50 years away from current year, so the user could continue at his/her own risk.

*Do not allow user to enter less than 4 digit on years
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 0005273 closeddbaz When entering dates with dd-mm-yy format are saved as dd-mm-00yy 

-  Notes
(0013282)
dbaz (developer)
2009-02-10 02:30

Since it is a minor bug (almost a feature request) with few impact but huge risk, it won't be backported

- Issue History
Date Modified Username Field Change
2008-09-29 09:57 psarobe New Issue
2008-09-29 09:57 psarobe Assigned To => dbaz
2008-09-29 09:57 psarobe Status new => scheduled
2009-02-10 02:30 dbaz Regression testing => No
2009-02-10 02:30 dbaz Status scheduled => closed
2009-02-10 02:30 dbaz Note Added: 0013282
2009-02-10 02:30 dbaz Resolution open => suspended


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker