Subtact days from an exact date

[Ismail Qadry]

Greetings All,

Apologies if this has already been asked and answered but I didn't have much luck finding the details with my search.

I am trying to track stories that have advanced to specific status based on exact date less a certain number of days.

For example.

• What stories had a status changed to Done  7 days before 2018/09/12
• What stories had a status changed to In QA 14 days before 2018/09/12
• What stories had a status changed to In Progress 21 days 2018/09/12

I could manually create the filters with the specific dates but I'd like to be able to modify a single date and have all filters reflect the different "exact date".

Thank you!

[Carlos Garcia Navarro]

Hi Ismail,

Would this work for you?

project in (PROJECT) AND status changed from "Open" to ("Resolved", "Verified") during("2018-09-05", "2018-09-12")

Carlos