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

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

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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Wednesday in Jira

Join our webinar: How 1B+ feature flag events helped us build the new Jira

Every time you release software, there's a bit of risk – that there's a bug, that something breaks, or that the feature doesn't resonate with customers. Feature flagging helps make high stakes s...

94 views 0 1
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