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

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0005290

Openbravo ERP

B. User interface

public

2008-09-29 09:57

2009-02-10 02:30

Reporter

plujan

Assigned To

dbaz

Priority

normal

Severity

minor

Reproducibility

have not tried

Status

closed

Resolution

suspended

Platform

OS Version

Product Version

2.40

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

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

Description

On 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 Reproduce

1. 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

Additional Information