JQL "resolved <= 2014-06-30" expression doesn't include issues resolved on the 30th

I've noticed that when an issue is resolved on the last day of the month then such a query won't include them: resolved >= 2014-06-01 AND resolved <= 2014-06-30 AND assignee in ("name")

I thought that maybe my timezone and JIRA's is different but it isn't (it's the same; although in JIRA System settings as the time zone it says "Berlin (GMT+1)" however the time zone of Berlin is GMT+2 hours currently because of summer time): I resolved the affected issues on the 30th at 23:50 (as seen in the issue's history).

So is there a bug in JQL or is there a bug in JIRA not handing daylight saving time?

1 answer

1 accepted

1 vote
Accepted answer

No, this is not a bug. There is a time part to each date so if the issue is resolved on 2014-06-30 13:00 the expression resolved <= 2014-06-30 returns false since it will be interpreted as resolved <= 2014-06-30 00:00

Interesting, thanks!

Henning Tietgens Community Champion Jul 01, 2014

Exactly. Instead use resolved < 2014-07-01 or resolved <= "2014-06-30 23:59:59".

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,301 views 12 19
Read article

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