Report on changes that has been open for more than 7 days

Thereza Van der
Tera Contributor

Hi

 

I would like to create a report that shows all changes that has been left open 7 days after implementation date/planned end date.

 

I used the relative operator but struggle to get it to show the correct info.

 

Any guidance would be appreciated, thanks.

 

Regards

Thereza

3 ACCEPTED SOLUTIONS

Bert_c1
Kilo Patron

Hi Thereza,

 

Do the following conditions work for you?

 

Screenshot 2023-07-21 103044.png

 

If so, you can define a report with the same conditions.

View solution in original post

Hi Thereza,

 

There is also "at or before", "Last 7 days" as in below

 

Screenshot 2023-07-21 112811.png

that does use week. I'm glad I helped.

View solution in original post

Bert_c1
Kilo Patron

Hello Thereza,

 

I believe using "Week" will use Sunday as boundaries, but I found:

 

Condition Builder - Date/Time fields

 

Which confirms my thinking.

View solution in original post

6 REPLIES 6

Bert_c1
Kilo Patron

Hello Thereza,

 

I believe using "Week" will use Sunday as boundaries, but I found:

 

Condition Builder - Date/Time fields

 

Which confirms my thinking.

Hi 🙂

 

Thank you so much, this really helps a lot. I downloaded the 'Values for date/time fields' cause I am going to use it a lot in future. 

 

Regards

Thereza