My Test Example Has 32 Incidents but One Does Not Have Any Journals

My test example has 32 Incidents but one does not have any Journals.

I used SQL to modify the Journal Date (I used Last Modified instead of Created) of all Journals and then ran a search based on 5 Business Days and then another on 5 (24x7) days.

The test was run on the 27th and I ran tests with the Journal dates set between the 19th and 23rd.

Initially I used the Greater Than condition but also re-ran the tests to use the Less Than condition.

The results are:

Business Hours / 24 x 7
Cut-off date / Journal Date / Incident Has Journals / Num if GT / Num if
LT / Cut-off date / Journal Date / Incident Has Journals / Num if GT / Num if
LT
20/Aug / 23/Aug / Yes / 1 / 32 / 22/Aug / 23/Aug / Yes / 1 / 32
20/Aug / 22/Aug / Yes / 1 / 32 / 22/Aug / 22/Aug / ? / 32 / 32
20/Aug / 21/Aug / Yes / 1 / 32 / 22/Aug / 21/Aug / No / 32 / 1
20/Aug / 20/Aug / ? / 32 / 32 / 22/Aug / 20/Aug / No / 32 / 1
20/Aug
Midday / 20/Aug
14:00 / ? / 32 / 32
20/Aug
Midday / 20/Aug
10:00 / ? / 32 / 32
20/Aug / 19/Aug / No / 32 / 1 / 22/Aug / 19/Aug / No / 32 / 1
Cut-off date is the date that should be calculated by the 5 Day Old expression
Journal Date is the date I have forced all Journal Entries to (I have ignored Time for now)
Incident Has Journals is whether I believe that the Incident has Journals falling in the 5 day period – note on the actual Cut-off Date I have set it to ?as time will have affect here.
Num if GT is the number of Incidents returned by my search if I use Greater Than
Num if LT is the number of Incidents returned by my search if I use Less Than