Any date validate function

mouthou · Post by **mouthou** » Thu Apr 03, 2008 2:03 pm

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.

trammohan · Post by **trammohan** » Thu Apr 03, 2008 2:15 pm

try this one

IsValid("date",Str)

ray.wurlod · Post by **ray.wurlod** » Thu Apr 03, 2008 5:01 pm

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