Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Jira software has issue when it stored data with datetime field

Nguyễn Thành Hải July 11, 2019

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!

Capture.PNG1.PNGimage_2019_07_09T10_17_32_392Z.png

image_2019_07_11T02_51_16_041Z.png

1 answer

1 accepted

0 votes
Answer accepted
Petter Gonçalves
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
July 15, 2019

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.

Nguyễn Thành Hải July 15, 2019

Thanks so much, Petterson!

Petter Gonçalves
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
July 16, 2019

You are welcome, Hai!

Have a nice day. :)

Suggest an answer

Log in or Sign up to answer