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
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

date calculation in JQL

EricMa
EricMa September 23, 2022

How can I search for the issues switched to "Done" within the last 2 weeks?

 

I don't know how to perform "date calculation" such as today - 14 days...

Answer
Watch
Like Be the first to like this
745 views

2 answers

2 accepted

1 vote
Answer accepted
Ollie Guan
Ollie Guan
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
September 23, 2022

Hi @EricMa ,

resolutiondate >=-14d

View More Comments
EricMa
EricMa September 23, 2022

Works perfectly. Thanks

Like • Ollie Guan likes this
Reply
1 vote
Answer accepted
Fabio Racobaldo _Herzum_
Fabio Racobaldo _Herzum_
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
September 23, 2022

Hi @EricMa ,

you could use date specific functions (https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/)

Example :

resolved > startOfDay(-14) 

resolved > startOfWeek(-2)

Hope this helps,

Fabio

View More Comments
EricMa
EricMa September 23, 2022

Super!

Thanks

Like • Fabio Racobaldo _Herzum_ likes this
Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira Software
DEPLOYMENT TYPE
CLOUD
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events

    See all events