Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Marvo Barker January 30, 2023

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

0 answers

Suggest an answer

Log in or Sign up to answer