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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Exactly. Instead use resolved < 2014-07-01 or resolved <= "2014-06-30 23:59:59".
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This is also explained in the docs - https://confluence.atlassian.com/display/JIRA/Advanced+Searching#AdvancedSearching-Resolved
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.