I want to share the problem that happened with my system. I'm using Jira v 7.10.1 with MSSQL 2012.
When I input the date field with the dd/MM/yy format (for example: year 19 instead of 2019), I receive a warning message on the application as shown. It is worth mentioning that the system has still stored these tickets. This is a bug of Jira software, right? I think this warning comes from the database that the application couldn't validate.
Could you help me to explain this issue?
Thanks!
Hello Hai,
Indeed, the behavior you mentioned is a bug in JIRA. It happens only for some wrong formats added to the Date/time fields, especially when you update the original Date picker format to a different one.
We have a bug reported about this here:
- Date format breaks issue creation
Feel free to vote and watch the bug to receive notifications about any updates.
Additionally, I suggest you follow the workaround steps below and check if it properly works for you:
- Avoid modifying the format of the date picker in JIRA's Advanced Settings, and use the default format instead, which seems to have a better functioning handler for invalid values
- Use the widget to select your date picker value, rather than typing it in. This will avoid improper formatting
- For the above example specifically, adjust the format from MM/dd/yyyy to MM/dd/yy. This will accept values where only the last two digits of the year value is offered, but may lead to inconsistent results (testing results show that a year value of "37" will assume 1937, but a year value of "36" will assume 2036).
Let me know if you still have any questions.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You are welcome, Hai!
Have a nice day. :)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.