Hello,

I'm trying to use device collection query to get a list of computers that have a specific software (Application A) not installed on Apr 16. So i would create a criteria with:

Installed application (x64) history > Display Name. Set string to "Application A"
Installed application (x64) history > Installed Date. Set Installed Date to "is no equal to" 20150416.   

When i query the collection it should list all systems with all version of application A not installed on Apr 16. However, it ends up showing only Application A installed on Apr 16.

you can try sub selected quires using Not IN Condition menans first get list of computers that have Application A with installed date 20150416 and sub selected query to get rest of the computers that have Application A . More via  http://eskonr.com/2011/12/sccm-collection-sub-selected-quiries/

http://blogs.msdn.com/b/muaddib/archive/2008/10/10/sub-select-query-the-holy-grail-of-sms-collections.aspx