Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Get started Tell me more

4,365,310

Community Members

Community Events

168

Community Groups

Community
Products
Jira
Questions
date calculation in JQL

date calculation in JQL

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...

2 answers

2 accepted

1 vote

Answer accepted

Hi @EricMa ,

resolutiondate >=-14d

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Works perfectly. Thanks

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • Ollie Guan_携程_ likes this

1 vote

Answer accepted

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Super!

Thanks

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • Fabio Racobaldo _Herzum_ likes this

Suggest an answer

Was this helpful?

Thanks!

Jira

DEPLOYMENT TYPE

CLOUD

PERMISSIONS LEVEL

Site Admin

Products

Community resources

Support

Interests

Community resources

Support

Top groups

Community resources

Support

Come for the products,
stay for the community

date calculation in JQL