How to filter out change request planned start or end date fall into a specific date range

[MB Ng]

Hi,

I would like to filter out all change request planned start date or end date which fall into a specific date range and display in list view, any idea on the report filtering?

e.g. expect below 4 change requests are show in the report, given those planned start date or End date fall into specific date range e.g. 28th-30th Jun 2022

CHG No.	Planned start date	Planned End date
CHG00001	15th June 2022 00:00:00	28th June 2022 23:59:59
CHG00002	27th June 2022 00:00:00	28th June 2022 23:59:59
CHG00003	29th June 2022 00:00:00	02nd July 2022 23:59:59
CHG00004	30th June 2022 00:00:00	10th July 2022 23:59:59

[Sagar Pagar]

Hi,

Can you explain your business requirement? It is not enough details for understanding.

Thanks,

Sagar Pagar

[MB Ng]

Would like to know how many change request fall into the specific date range .e.g. 28th-30th Jun 2022 for review purpose.

Right now we always export all the change request and eyes ball to point out the change request fall into the specific date instead of using report filtering

[Harish KM]

Hi You can filter based on Planned Start date and Planned  end date. test around conditions at or afer, at or before. You can playaround with filter conditions to get desired result.

[MB Ng]

yes, try it before, when use "at or after" which can select one single date. e.g

at or after 28th Jun 2022, then only highlighted will show in list view, even included other unnecessary ticket record

CHG No.	Planned start date	Planned End date
CHG00001	15th June 2022 00:00:00	28th June 2022 23:59:59
CHG00002	27th June 2022 00:00:00	28th June 2022 23:59:59
CHG00003	29th June 2022 00:00:00	02nd July 2022 23:59:59
CHG00004	30th June 2022 00:00:00	10th July 2022 23:59:59

So looking for filter condition that can show how many change request fall into the specific date range.