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 :)