Dates in queries are incorrect but the ticket date is correct / JRE requriement question

We upgraded from 5.0 to 5.1 and afterwards, the dates in our queries are no longer working. In the Issue Navigator they show up as being from '59,'80,'13,'65... and they are all from 2009 and beyond. When you go into the issue / ticket itself the dates are correct.

Secondly is there any reason we cannot upgrade to JRE 7 U 5 vs JRE 6 U 31?

3 answers

Just noticed that queries against custom fields are no longer returning correct results also.

Hi John,

If you are already running JIRA on JAVA 7, then I will recommend that you downgrade the JDK to 6 which is the current supported platform for JIRA 5.1:

We are currently running 6 u 31, just wanted to know if we could upgrade. I still have a major issue with the dates and custom fields!

I have modified the date format fields, and the YEAR part of the date is completely fubar! using the mm/dd/yyyy format gives 8 character long years. using the dd/MMM/yy gives years that range all over the century. When querying the DB, the dates are correct. When viewing the tickets in Jira they appear correct.

When you view them in the issues results they are wrong.

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Julia Dillon
Posted Apr 17, 2018 in Jira

Tell us how your team runs on Jira!

Hey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...

800 views 2 19
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you