nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Zoltán Lehóczky

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?

Accepted answers

Udo Brand

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

All comments

Udo Brand

Zoltán Lehóczky

Interesting, thanks!

Henning Tietgens

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

Dave

This is also explained in the docs - https://confluence.atlassian.com/display/JIRA/Advanced+Searching#AdvancedSearching-Resolved

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud