Looking for a query to show epics/stories where the 'target end' date has already past

[Marvo Barker]

Hi all,

I am looking for a query that will show the epics/stories where the ‘target end’ date has already past, for example December 31st 2022.

I was able to take a query from another teams roadmap and amend it to show any epics/stories within the next 18 months and that works (below). I am just having any issue being able to work out how to show anything that has already gone past.

"parent link" = xxx-46 AND ("Target start" >= now() AND "Target start" <= startOfDay("+3M") OR "Target end" <= startOfDay("+18M") AND "Target end" >= now())   

Any guidance is appreciated :)