Filtering a straight table

Thu, 20 Dec 2012 09:57:52 GMT

I want to do a select in a field or filter a straight table to get the data I want.

The condition is like this.

I want to select all possible rows that do not exists in another logical table or if the end date is more than 3 months old (of the newest record).

I was trying to do something like this in expression in a straight table so the table will supress all other records.

if(IsNull(EndDate)=-1 or max(EndDate) < '1.9.2012',1)

but then I get records that have more than one record in this specific table and one of them have EndDate that is newer than 1.9.2012.

regards, Kari

Re: Filtering a straight table

Thu, 31 Jan 2013 10:32:12 GMT

I needed to use Count = 0 instead of isnull() = -1

(

max([EndDate])<'$(varEndDate)' or count([EndDate])= 0

)