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

[Thereza Van der]

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

[Bert_c1 · Accepted solution]

Hi Thereza,

Do the following conditions work for you?

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

[Bert_c1 · Accepted solution]

Hi Thereza,

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

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

[Bert_c1 · Accepted solution]

Hello Thereza,

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

Condition Builder - Date/Time fields

Which confirms my thinking.

[Thereza Van der]

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