Create filter with relative date

[Roms Roms]

Hello,

I would like to create a filtre using jsql with a relative date to get JIRA resolved within the last 30 days, something like :

- resolved>=now()-30

Any idea ?

Thanks

[Thomas Schlegel · Accepted solution]

Hi,

try this:

resolved > -30d

Cheers

Thomas

[Roms Roms]

It works, thanks a lot :)

[Naresh Kumar]

Thanks. I was looking something similar. It works.

[Chris Fouts]

Along the same lines, how can I create a filter for issues that have due dates between today and the next seven days, inclusive?

[Radek Janata]

@Chris Fouts

duedate > now() AND duedate < 7d

duedate > now() AND duedate < 7d AND resolution is EMPTY

[Tarek Faham]

This is very useful. Is there a document/reference in JIRA that explains how to use this form? For example, can I use this form:

created < -1m AND duedate < 2y

[Richard Cross]

You can't do that, Valid formats are:

• 'yyyy/MM/dd HH:mm'
• 'yyyy-MM-dd HH:mm'
• 'yyyy/MM/dd'
• 'yyyy-MM-dd' 

or a period format using w = weeks, d = days, h = hours, m = minutes

e.g. '-5d' or '4w 2d'.

[Susan Mulard]

Thanks to you all!! Very useful information!

[Khaled Arafat]

Thanks a lot ,

It worked 

Cheers!

[Deleted user]

You can also view only the recently updated issues, say in the last 4 weeks, in the following manner:

 updatedDate >= -4w

[Deleted user]

I am trying to create a filter for created vs resolved in 30 days   

is this correct ?

 (resolution = Unresolved OR resolution = Fixed) AND created > -30d AND resolved > -30d

[Radek Janata]

If you mean issues that are both created and resolved in last 30 days, then this is the simplest notation:

created > -30d AND resolved > -30d

Only issues with Resolution set are resolved. If resolution is empty, the issue does meet "resolved" condition.

[robin.fielding]

This helped me out a lot, thanks very much.

[1st line support KPMG]

How can I filter to see request created since 2018 till now. Please advise

[Radek Janata]

created > 2018-01-01

[José Agnaldo B_ de Sousa]

Hi, i need a query to show the tickets created greater than 6 months and less than 1 year from now.

Thanks. 

[Radek Janata]

created < -180d AND created > -365d

You need to use days "d" as "m" is reserved for minutes and "M" doesn't work. See also Advanced searching - fields reference in Atlassian Documentation.

[José Agnaldo B_ de Sousa]

Thanks.

[Yasser_Abdallah]

resolved > -30d

[Gabriel Marcopulos]

Hi,
It worked for me too.
I needed to perform a trigger that obtains issues that were in a same priority during a specific period of time and then, move them to higher priority.
Thanks a lot for all your help!
Cheers

[Deleted user]

I am looking for a filter to pull issues created over 6 months ago.  I tried created > -180d, created >= -6m, created >= endofmonth(-5) and none of them seem to work.  

I also tried using createddate vs. created, but not getting the results I am looking for.  Any ides on how to create this filter?

[Urszula Forenc]

Hi,

maybe this: created <=  endOfDay(-6M)

[Deleted user]

created <=  endOfDay(-6M) didn't work, but by making a minor change to your suggestion, it worked.  I used created<=endOfDay(-180d).  Thank you so much for your help.

[Urszula Forenc]

Sometimes it works with "M", sometimes with "d", I don't get it ;)

[Urszula Forenc]

How can I create it with years? -3y doesn't work.

[cdowideit]

How about 36m?

[Urszula Forenc]

Instead of now() I did sth like this:

project = Rec AND "App Date" < startOfDay(-3y)

Now it works great.

[Deleted user]

Thanks it works now !