>>>>Try
>>>That seems to fail on the min() function call, it's expecting 2 arguments...
>>>
>>
>>Typo. It should be
>>select GOMONTH(min(EVL(rr.re_date, {^9000-12-31})), -216)
>>
>
>Yeah I spotted that ;-)
>
>Thanks for both of your responses, however I'm getting the same results :-(
>
>Kev
Can you post the result of SYS(3054) for all queries?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.