I don't want these rows to appear in my search so the criteria must not be working correctly. What can I change?

TRUNC() the fields in the criteria?

CASE WHEN (TRUNC({expectedreceiptdate}) < {today}) THEN 1 else 0 END CASE WHEN (TRUNC({expectedreceiptdate}) < TRUNC({today}))THEN 1 else 0 END Both do not change the output.

While it's not the same as what you have, I tried this on a search and it worked:

case when trunc({lastrunon}) < trunc({today}) then 1 else 0 end

only difference I see between this and the 2nd example you provided is i don't have the TRUNC comparison wrapped in parentheses - perhaps removing those would work. Also, is END DATE in your results the same as {expectedreceiptdate}?

I think I might have done something wrong with the parentheses - I just copied your example and changed the ids and it now seems to work! Thanks for this!