Creating Dynamic Date JQL filter

JAMES Brown April 19, 2016

I know how to create a JQL filter already with the following line

"CM Complete Date" >= 2016-02-01 AND "CM Complete Date" <= 2016-02-29

What I would like to do is have the date always use the start and end dates for the previous month with out having to change the dates. Is this possible?

2 answers

1 accepted

3 votes
Answer accepted
Michael Partyka
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 19, 2016

James,

 

try this:

"CM Complete Date" &gt;= startOfMonth(-1) AND "CM Complete Date" &lt;= endOfMonth(-1)
0 votes
JAMES Brown April 19, 2016

Thank you.  That worked perfectly.

Suggest an answer

Log in or Sign up to answer