>>select date(yr,mn,1) as sysDate from result into cursor dates
>>yr is numeric
>>mn is numeric
>>
>>what's wrong with the function? i.e. if i type ?date(yr,mn,1) in the command window, I get a date result
>
>this will work as long as yr and mn have correct values.
>Perhaps you have one (or more) records with a 0 (zero) or .NULL. in at least one of the fields!?
>In this case, the execution would fail and you would get the error you have mentioned.


That's it!

Thanks again,
Mike