How to filter jira by updated date dynamically?

Anthony Kong August 1, 2012

I want to define the qury in my filter to be:

project = 'myproject' AND assignee = me AND status in (Open, "In Progress", Reopened) and updatedDate between yesterday and the-day-before

how can i express this condition: "updatedDate between yesterday and the-day-before"?

If it can be made to work on business date rather than calender day, it is even better

1 answer

1 accepted

0 votes
Answer accepted
Christian Czaia _Decadis AG_
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.
August 1, 2012

Hey,
if you're looking for issues that have been updated "yesterday" or the day before yesterday your JQL could look sth. like this:

updated >= endOfDay(-3d) AND updated < endOfDay(-1d)

Cheers Christian

Suggest an answer

Log in or Sign up to answer