>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.
Holger Vorberg
Germany
