>>>>select * >>>> from person p >>>> inner join referral r on p.cl_ref = r.cl_ref >>>> where p.cl_dob > ( >>>> select GOMONTH(min(EVL(rr.re_date, {^9000-12-31}), -216)) >>>> from referral rr >>>> where rr.cl_ref = p.cl_ref ) >>> >>>That seems to fail on the min() function call, it's expecting 2 arguments... >>> >>>Thanks >>>Kev >> >>No, MIN() in SQL SELECT is totaly different function. It gets minimum value of the expression and requires nly one parameter. > >Yes I'm aware of that but something tells me you won't be able to apply it as an argument for the gomonth function. This can't be true. Sergey misplaced brckets! <pre> GOMONTH(min(EVL(rr.re_date, {^9000-12-31})), -216)