Jira software has issue when it stored data with datetime field

Nguyễn Thành Hải_csv3l4

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!

Petter Gonçalves

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.