- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-21-2023 04:04 AM
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-21-2023 07:32 AM
Hi Thereza,
Do the following conditions work for you?
If so, you can define a report with the same conditions.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-21-2023 08:29 AM
Hi Thereza,
There is also "at or before", "Last 7 days" as in below
that does use week. I'm glad I helped.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-21-2023 10:06 AM
Hello Thereza,
I believe using "Week" will use Sunday as boundaries, but I found:
Condition Builder - Date/Time fields
Which confirms my thinking.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-21-2023 10:06 AM
Hello Thereza,
I believe using "Week" will use Sunday as boundaries, but I found:
Condition Builder - Date/Time fields
Which confirms my thinking.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-03-2023 07:46 AM
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