Defect #17698: Date format is incorrect - Redmine

Actions

Copy link

Defect #17698

open

Date format is incorrect

Added by Viktor Petersson over 10 years ago. Updated about 2 years ago.

Status:

Needs feedback

Priority:

Normal

Assignee:

Category:

Roadmap

Target version:

Start date:

Due date:

% Done:

Estimated time:

Resolution:

Affected version:

2.5.2

Description

I recently upgraded to 2.5.2 and ran into an issue when setting the end date for a Roadmap.

The error I got was:

Date is not a valid date.

After more investigation, I noticed that the date picket inserts the date in the following format:
08/18/2014

It should however be saved as:
2014-08-18

My guess is that this is in the datepicker itself, and that it tries to autodetect depending on your locale etc, so it might not be showing up to all users.

The current workaround is to manually enter the date format in the required format.

My system:

Chrome 36.0.1985.143 (Official Build 287914)
Language: US EN
OS X 10.9.4

Files

Download all files

Screen Shot 2014-08-15 at 6.58.47 PM.png (56.1 KB) Screen Shot 2014-08-15 at 6.58.47 PM.png		Viktor Petersson, 2014-08-15 18:59
redmine.png (121 KB) redmine.png		Max Drechsler, 2015-03-25 09:23

Related issues

Actions

Copy link

Updated by Toshi MARUYAMA about 10 years ago

Status changed from New to Needs feedback

I cannot reproduce.
Redmine uses 'yy-mm-dd' format.

I think plugin or browser causes problem.

Actions

Copy link

Updated by Laurent Bauer almost 10 years ago

I can also reproduce the same problem.
The datepicker does render the chosen date in the right format, the problem actually occurs when loading the form.
I guess the date is loaded from the database in the wrong format.
I set redmine database datestyle set to 'ISO,MDY', could there be a wrong setting on the client side ?

Actions

Copy link

Updated by Max Drechsler over 9 years ago

File redmine.png redmine.png added

Have the same issue. Redmine version is 3.0.1
When saving the Issue, redmine complains about invalid date format.
Browser is Firefox 36. Language setting is German.

Actions

Copy link

Updated by Laurent Bauer over 9 years ago

I set redmine database datestyle set to 'ISO,MDY', could there be a wrong setting on the client side ?

The answer is "no, but..." it seems redmine needs to be restarted after fixing the database datestyle. In my setup (redmine 2.6.1) the dates form inputs are still loaded with the previous datestyle until I restart redmine.

I believe it might help to mention that in the wiki http://www.redmine.org/projects/redmine/wiki/RedmineInstall#Supported-database-back-ends.

Actions

Copy link