Showing results for 
Search instead for 
Do you mean 

HELP REQUIRED!!! 'Not Equal to (!=)' Search options (Act Version

New Member
Posts: 1
Country: United Kingdom

HELP REQUIRED!!! 'Not Equal to (!=)' Search options (Act Version


After some advice please with the  'Not Equal to (!=)'   field.


Is there a way of excluding a date range using a wilcard type symbol?  E.G. to exclude say March 2011 I would enter something like   ##/03/2011   ?   Other wise I would have to go through every day of the month excluding each date, and I have dozens of categories. 


In simple terms this is what the lookup should be doing per month. This example is for March this year:

Product 1 renewals 2011>Product 1 renewals March>Exclude any Product 2 renewals March 2011


What I want to be left with each month is a separated list for Product 1 that excludes any Product 2 renewals.



Any assistance would be gratefully received.