DSXchange

Hello All,

I was trying to find some routine or function to validate the incoming source DATE values.
Sometimes the source is deriving (from other date columns) and sending invalid dates like 31-sep-2007. But there is no 31 in September. Is there any function like IsValidDate in datastage or it has to be custom defined. Could your share your ideas in case you encountered this situation.

Thanks for your help.

try this one

IsValid("date",Str)

Search the forum to find where a server version of IsValid() can be obtained.