Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Product Q&A
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

How to calculate two distinct dates with JQL?

Wilson_Lucena
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!
Get involved
July 1, 2019

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

Answer
Watch
Like Be the first to like this
259 views

2 answers

1 vote
Jack Brickey
Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
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

Reply
0 votes
Kian Stack Mumo Systems
Kian Stack Mumo Systems
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
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

Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira
TAGS
AUG Leaders

Atlassian Community Events

    See all events