How can we filter on change table for planned start and planned end data which changes on every week

[Shivani Sahu]

I have a requirement to create a report on change request table for planned start and planned end date.

The planned schedule start and end date changes every week. Planned schedule start : Monday to Sunday of the current week and end date is at or after Saturday of the current week.

Screenshot attached for the sample where I have mentioned the days on date wise. Exactly the same filter we'll have to apply on report as per the days for every week. 

Please share the inputs if anyone knows and can help on the same.

[AndersBGS]

Hi @Shivani Sahu ,

i'm not 100% sure about your requirement, but as I understand it, you need the attached report generated on weekly basis. If this is correct, wouldn't below filter solve the issue:

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[Shivani Sahu]

Hi ander,

The planned start date should be on the current week that is right it should be on this week..

But planned end date should be at after Saturday of this week..

That's all the requirement. I have also used the trend filter on planned end date but it is giving the result of (any Saturday) I need the end date at or after Saturday of the current week only.

[AndersBGS]

Hi @Shivani Sahu ,

I think below filter will solve you requirement. As I understand you, planned start date should be on current week, at planned end date should be on upcoming week.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders