Subtact days from an exact date

Ismail Qadry September 12, 2018

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!

 

1 answer

0 votes
Carlos Garcia Navarro
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 12, 2018

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

Suggest an answer

Log in or Sign up to answer