JQL script to exclude a range of resolution dates from within a range of resolution dates.

[Jason Michaud]

Do you know of a way to exclude a range of resolution dates from within a range of resolution dates.

I want to create a query of resolved tickets from the start of month to the end of day yesterday - but I want to exclude any tickets resolved between 2/8/18 730pm and 2/9/18 600am. Below is what I tried - but I'm not getting it.

project = "IS" AND issuetype in ("Emergency Change Management", "Service Request", "Standard Change Management", "System Change Management", "User Incident", Sub-Task) AND ((resolved >= startOfMonth()) AND (resolved < "20180208 1930")) OR ((resolved > "20180209 0600") AND (resolved <= endOfDay(-1))) ORDER BY resolved ASC

[Nic Brough -Adaptavist-]

One more bracket...

Change

AND ((resolved >= startOfMonth()) AND (resolved < "20180208 1930")) OR ((resolved > "20180209 0600") AND (resolved <= endOfDay(-1)))

To

AND ( ((resolved >= startOfMonth()) AND (resolved < "20180208 1930")) OR ((resolved > "20180209 0600") AND (resolved <= endOfDay(-1))) )

[Jason Michaud]

Thank you Nic - but I am still getting the same results. I am still seeing resolved tickets between the hours of 2/8/18 730pm and 2/9/18 600am that I want to exclude from the range.

project = "IS" AND issuetype in ("Emergency Change Management", "Service Request", "Standard Change Management", "System Change Management", "User Incident", Sub-Task) AND ( ((resolved >= startOfMonth()) AND (resolved < "20180208 1930")) OR ((resolved > "20180209 0600") AND (resolved <= endOfDay(-1))) ) ORDER BY resolved ASC

[Jason Michaud]

Thank you Nic again - I figured it out - it was the date formatting.

((resolved >= startOfMonth()  AND resolved < "2018-02-08 19:30")  OR  (resolved > "2018-02-09 06:00" AND resolved <= endOfDay(-1)))