Selecting a change request with an interactive filter

[chrifan]

Hi, I want to select a change request or more beeing active on a date I define with an interactive filter e.g. today. My concern is that not all changes running today are displayed.

I build my filter this way: work_date, start_date and end_date

In my list are change requests with a work/start_date far earlier today und end_date far beyond today. These ones are not displayed although they are still active.

Thx

Version is UTAH; no code strict, reports

[Mark Manders]

Can you share a screenshot of your filter?

[chrifan]

[Mark Manders · Accepted solution]

If you select 'today', it will only show you the changes where one of those fields is actually on today. I think you need 3 filters for your requirement: set your startdate to before today and the end date to after today. Checking 3 fields on one table can also cause confusion. You select 'next week' and all changes with an end date on next week will show up and all changes with a start date on next week, but it doesn't tell you which is which.