Project

General

Profile

Actions

Defect #17698

open

Date format is incorrect

Added by Viktor Petersson over 9 years ago. Updated over 1 year ago.

Status:
Needs feedback
Priority:
Normal
Assignee:
-
Category:
Roadmap
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Affected version:

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

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

Related to Redmine - Defect #20244: Upgrade from 2.6 to 3.0 (Stable) :: Is not a valid date by all Date fieldsNeeds feedback

Actions
Actions #1

Updated by Toshi MARUYAMA over 9 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 #2

Updated by Laurent Bauer about 9 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 #3

Updated by Max Drechsler almost 9 years ago

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.

redmine.png

Actions #4

Updated by Laurent Bauer almost 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 #5

Updated by Toshi MARUYAMA over 8 years ago

  • Related to Defect #20244: Upgrade from 2.6 to 3.0 (Stable) :: Is not a valid date by all Date fields added
Actions #6

Updated by Vlad Vor over 8 years ago

Redmine is unusable with this bug. Could somebody fix it quick in dev?

Actions

Also available in: Atom PDF