>>I have a cursor called Result
>>It has a number of fields in it, of which 2 are yr=year and mn=month
>>
>>The error I am getting is:
>>Function argument value,type or count is invalid.
>>
>>
>>I have reduced the select that is causing me grief to thus
>>
>>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
>>
>>I'm going to bed now, it is not obvious... at least to me.
>>
>>Mike
>
>It works for me:
It works for me too.