Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

jql with a range of dates

Alejandra April 12, 2021

Hi, 

I'm executing the follow jql:

project = SIS AND "Customer Request Type" not in ("Auditoría o Vulnerabilidad (SIS)", "Extracción ficheros Anadat (SIS)") AND issuetype != Tarea AND status changed to closed after "2021/03/15" before "2021/03/21"

I obtain 125 issues.

If i execute the next one

project = SIS AND "Customer Request Type" not in ("Auditoría o Vulnerabilidad (SIS)", "Extracción ficheros Anadat (SIS)") AND issuetype != Tarea AND status changed to closed during ("2021/03/15", "2021/03/21")

 

I don't know why i obtain a different numbers of issues. It seems that the first one doesn't shows the issues of day 2021/03/15, is it because the hour? 

 

Thank you! 

1 answer

1 accepted

2 votes
Answer accepted
Walter Buggenhout
Community Champion
April 12, 2021

Hi @Alejandra,

the AFTER in your first JQL statements makes the search start on 2021/03/16, whereas the DURING statement of your seconds statement includes both start and end dates.

I hope this helps! 

Alejandra April 12, 2021

thanks a lot @Walter! now i feel myself a little bit silly... :)

Thank you so much!!

Like Walter Buggenhout likes this
Walter Buggenhout
Community Champion
April 14, 2021

Don't feel silly @Alejandra :-) - those who never ask a question will never get smarter (or it will take them much longer at least)!

Like Alejandra likes this

Suggest an answer

Log in or Sign up to answer