How to calculate two distinct dates with JQL?

Question

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

Kian Stack Mumo Systems · Answer

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

Jack Brickey · Answer

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