Relative field not working as expected

[Thereza Van der]

Good afternoon all 🙂

I would like your input please. I have a report that is supposed to show all changes from a Tuesday till the following Monday. If I use the relative field it does not work as expected.

The first part is working (relative after 5 days) so it always starts with the changes for the Tuesday, but I am battling with the second half. If I say 'relative before 13 days ahead', it misses one change and if I say 'relative before 14 days ahead' it adds two changes for the next Tuesday. I know 14 days is incorrect, because I want 7 days of data (Tuesday till Monday) and 14 minus 6 is 8. But why does 'relative before 13 days' not pick up the one change? I attach screenshots for your convenience. I really hope someone can show me what the problem is.

[Mark Manders]

And this report shows differences when? When you call it now, or does it show wrong changes in the report when it runs on the schedule? Or is the issue that the same filter is on the CAB board and it shows too many changes there?

[Thereza Van der]

Morning Mark

In the Workbench I have a manual filter. I asked in the community a while ago if there is a way to have a relative filter for the CAB meetings, but I did not get a reply. The CAB filter says all changes with a planned start date from today (the day of the meeting, Tuesday) until the following Monday must be displayed.

So the report runs on a Wednesday at midnight and those changes are supposed to be the changes going to CAB the next Tuesday. When I check the workbench it is not always in sync with my report.

Scheduled report filter

CAB meeting filter