1 Reply Latest reply: Jan 31, 2013 5:32 AM by Kári Georgsson RSS

    Filtering a straight table




      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