Greetings,

I need to build a filter bucket that can reterive the following SQL:

 Select * From Stock s
Where (s.strCompanyRef = '6010' And s.dtmDate = '1993-01-04') OR
       (s.strCompanyRef = '6010' And s.dtmDate = (Select Max(s2.dtmDate) From Stock s2 Where s2.dtmDate < '1993-01-04'))

I know how to build expressions but I can't figuer out how to build an expression that has an aggregate as one of its operands!!

Use a FieldCompareExpressionPredicate with a setoperator Equal.

You've to apply the aggregate function to the setfield, which is abit cumbersome (first create the field, then set the aggregate, then pass it to the FieldCompareExpressionPredicate constructor)