Odd Search Behavior-Date Completed

[armsys]

Originally posted by armsys
The only possibility for your Search criteria grid to succeed is to be interpreted as the following logical expression:

(Reminder >= 0 minutes AND Begin Date <= 2/6/2009 AND Begin Date>=12/19/2008) AND (Date Completed = "" OR Date Completed NOT Exists)

By merely looking up the Search criteria grid in your test.urd, it seems to present the following logical expression:

((Reminder >= 0 minutes AND Begin Date <= 2/6/2009 AND Begin Date>=12/19/2008) AND (Date Completed = "")) OR (Date Completed NOT Exists)

What went wrong with my interpretation? Please help. Thanks.

Armstrong

Kinook,
Would you please rule which interpretation is correct with reference to the "Incomplete Items" search item?
The test.zip shows:
1. "Incomplete Item" search criteria which is referred in the above question;
2. "Date Completed" search item obviously misses the "abc" Appointment item.

Please help. Thanks.

Armstrong