filter: "target closure date is going due in next 30 days"

Pangianto Pang September 10, 2012

Hi all, im a newbie here.

How to do the above query? 'Target Closure Date' is a custom field. How to add more 30 days in the now() below?

project = EQAPSTAB AND "GERR Target Closure Date" <= now() ORDER BY issuetype DESC, key DESC

Thanks

1 answer

1 accepted

1 vote
Answer accepted
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 10, 2012

Now() really does mean "now", but you don't need it in relative dates.

Drop it completely and try <= -30d instead. (I'm a bit hazy on how the > < interact with +30d and -30d, but try it, check the results and you'll see how it works)

Pangianto Pang September 11, 2012

I used "30d" :) do not include the '+'

Suggest an answer

Log in or Sign up to answer