Jira query - show cards created between today and minus 14 days from today

jira jql
Samuel Meddows picture Samuel Meddows · Jan 9, 2015 · Viewed 24.6k times · Source

I can't seem to find a solution for my query in jira. I wish to only show cards created between today and -14 days from today.

I am thinking along the lines of created >= today(-14d) AND created <= today().

I can't seem to use today(-14d) in my version of Jira which is 6.1.5.

Thanks.

Answer

Carlos Fern&#225;ndez Moreno picture Carlos Fernández Moreno · Jan 9, 2015

You can use this JQL query:

created >= -14d AND created <= now()

See: https://confluence.atlassian.com/display/JIRA/Advanced+Searching

Related questions

JIRA JQL searching by date - is there a way of getting Today() (Date) instead of Now() (DateTime)

I am trying to create some Issue Filters in JIRA based on CreateDate. The only date/time function I can find is Now() and searches relative to that, i.e. "-1d", "-4d" etc. The only problem with this …

Read More
JIRA: Searching for all issues with a given link type

Is there a way to query for all issues with a particular link type? For example, let there be a dependency link where an issue can "depends on" another issue. Is there a query to find all issues that depend …

Read More
How do I query Jira to search for all issues that have been resolved within a length of time from when it was created?

For example, let's say I need to find all issues that were resolved within 1 week's time. I need something like: resolved - created < '1w' Another example: Let's say I have 3 issues: 1) created 2 days ago, resolved 1 day ago. 2) created 5 …

Read More