Reporting Challenge (Change Request) - Planned Start/Planned end that encompass certain day of week

[ITProMD]

Hello,

A customer I am assisting internally tracks deployments and their affected CI's, and they do so by reporting on the PLANNED START and PLANNED END dates. Customers report gets ran every Friday, to be used for any deployments that affect the Sunday of that same weekend.

Basically, anything that STARTS and ENDS on that SUNDAY, or that encompasses it. In this example, that Sunday would be 7/14, and anything with a date of 7/19 (aka the next Friday) would be too far, he is looking to not go beyond the week after with start/end.

Table: Task_CI (Change Request)

Examples that would show up on this report:
CHG01234: Planned Start 7/9 > Planned End 7/15
CHG012345: Planned Start 7/14 > Planned End 7/14

Example that shouldn't be:
CHG016434: Planned Start 7/10 > Planned End 7/12
CHG012445: Planned Start 7/19 > Planned End 7/24

I was able to get close by using the following filter conditions:
Planned Start > On this week > Trend on Sunday
Planned End > On this week > Trend on Sunday
--OR--
Planned Start > At or After = This Week
Planned End > On > Next Week
Planned End > Trend > Before Friday

We are running into limits as is, we're wondering if this is possible, or if we need to go with a more advanced options such a function field etc. Help greatly appreciated, thanks.

[Dr Atul G- LNG · Accepted solution]

Hi @ITProMD 

I think we can get this by Trend as operator. 

Try to run like this

[ITProMD]

Thank you.

This worked for the first part of the filter conditions, I was able to add an "or" all of these conditions must be met, to cover the other part needed and it seems to have satisfied the customers' requirements. Appreciate the assistance.

[Dr Atul G- LNG]

Good to know... @ITProMD