Forums

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

How to calculate two distinct dates with JQL?

Wilson_Lucena
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 1, 2019

project in(SDT21 , AM) AND  (resolutionDate- createdDate) <=30  AND createdDate = "2019-01-01".

2 answers

1 vote
Jack Brickey
Community Champion
July 1, 2019

In the specific case you have shown you are showing that you know the createddate to be 2019-01-01 and It seems you want to see all issue resolved during January. Assuming that is indeed correct then you could do the following...

Project in (a,b) and createdate = 2019-01-01 and resolutiondate <= 2019-01-31 and resolutiondate >= 2019-01-01

0 votes
Kian Stack Mumo Systems
Community Champion
July 1, 2019

Wilson,

there isn't a way to accomplish this within the basic functionality of jira. This could probably be accomplished using the "Scriptrunner for Jira" plugin. I'm guessing you could use their custom JQL functions to figure out this information.

Thanks,

Kian

Suggest an answer

Log in or Sign up to answer