Hi everybody,
I want to filter events from Mo to Fr and from 8:00 to 15:30 - see my filter in [Bildschirmfoto vom 2019-01-31 16-24-25.png]. The result works as expected, but it shows one additional event which is outside my filters - see an example in [Bildschirmfoto vom 2019-01-31 16-28-13.png].
Can you explain? Is this a bug?
Peter
Filter by date/time shows one wrong result per day
Filter by date/time shows one wrong result per day
- Attachments
-
- Bildschirmfoto vom 2019-01-31 16-28-13.png (34.15 KiB) Viewed 1489 times
-
- Bildschirmfoto vom 2019-01-31 16-24-25.png (32.47 KiB) Viewed 1489 times
Re: Filter by date/time shows one wrong result per day
If you mean the first event in the list, around midnight, then it is exactly what you asked for.
It's just not what you meant to ask for
Start: 01/28 23:50 (Monday) End: 01/29 00:00:00 (Tuesday)
Think about each filter line ...
Starts on Monday or later. Yes.
Ends on Friday or less. Yes.
Starts at 08:00 or more (yes, by 16 hours)
Ends at 15:30 or less (yes, by 15.5 hours).
So ... it's working as unintended.
You may need to tweak your logic, the brackets don't help, as (True and true) and (true and true) is going to come up "true" no matter how you slice it.
It's because the event straddles midnight, you're seeing an "edge case" that usually slips by in testing, and then bites people when systems go into use, if the event ended at 23:59:59 Monday, this wouldn't be happening (Ends at 15:30 or less: NO!)
It's just not what you meant to ask for

Start: 01/28 23:50 (Monday) End: 01/29 00:00:00 (Tuesday)
Think about each filter line ...
Starts on Monday or later. Yes.
Ends on Friday or less. Yes.
Starts at 08:00 or more (yes, by 16 hours)
Ends at 15:30 or less (yes, by 15.5 hours).
So ... it's working as unintended.
You may need to tweak your logic, the brackets don't help, as (True and true) and (true and true) is going to come up "true" no matter how you slice it.
It's because the event straddles midnight, you're seeing an "edge case" that usually slips by in testing, and then bites people when systems go into use, if the event ended at 23:59:59 Monday, this wouldn't be happening (Ends at 15:30 or less: NO!)
Re: Filter by date/time shows one wrong result per day
Thanks that did the trick.