General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2003 Server
>>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only