Defect #17698

Date format is incorrect

Added by Viktor Petersson about 8 years ago. Updated 24 days ago.

Status:Needs feedbackStart date:
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:Roadmap
Target version:-
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

Screen Shot 2014-08-15 at 6.58.47 PM.png (56.1 KB) Viktor Petersson, 2014-08-15 18:59

redmine.png (121 KB) 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 b... Needs feedback

History

#1 Updated by Toshi MARUYAMA about 8 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.

#2 Updated by Laurent Bauer over 7 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 ?

#3 Updated by Max Drechsler over 7 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

#4 Updated by Laurent Bauer over 7 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.

#5 Updated by Toshi MARUYAMA over 7 years ago

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

#6 Updated by Vlad Vor about 7 years ago

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

Also available in: Atom PDF