Hi,

I am reading records from a file and if values are valid then i am inserting records into table. I have a date column. Now, i want to check that whether date string is a valid date or not. How can i do this? Is any function available or i have to do scripting? Can anyone tell me?

Hi,

You can use function

nret = date.to.num( long yearno, long monthno, long month_dayno )

if nret value < 0 then it is not a valid date.

:)

Thank u. It worked perfectly.