JQL Filter Help

[AbrahamA]

Hello

I have a custom field "Target Date" (JIRA Date Time type custom field)

I want to create a filter using which I can identify all issues for which target date is < 30 days from current date. (Issues targetted for next 1 month)

status != Closed AND "Target Date" < endOfDay("+30d")

When this filter runs I get issues with Target date 20/Sep/12 which is past date. I want only those issues from today to next 30 days as target date.

I was reading https://confluence.atlassian.com/display/JIRA/Advanced+Searching and following

due < endOfDay("+1") which finds issues due by the end of tomorrow, somehow I understood this wrong.

Can you please tell me where I went wrong.

Thanks

Abe

[Jobin Kuruvilla [Adaptavist] · Accepted solution]

Try

status != Closed AND ("Target Date" >= now() AND "Target Date" < +30d)

If you just do "Target Date" < +30d, you will also get issues where target date is in the past.

[Zul NS _Atlassian_]

You could try include due > now() and see if this helps.