How to filter jira by updated date dynamically?

Question

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

Christian Czaia [Decadis AG] · Accepted Answer

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