How to check if a column is in valid date format

[DSguru2B]

O, the switch over, the switch over, why didnt it hit me, for some reason i thought something was going wrong on my end.
Well Sheema, thats a routine by Ray, so you could request him to make it visible for a day so that it can help you.

[sheema]

Hi Ray,

I need a routine which checks if the date is in valid format ,if not convert it into desired format.
I came to know that you have a routine written for this purpose,can you please display it .

Thanks

sheema

[kumar_s]

Since server jobs are lacking in IsValid() function. Follow Ray's approach to use Status() to check if the conversion using ICONV() is valid and assing NULL based on the result.

[ray.wurlod]

I do have a server IsValid() function. However, I'm not at a DataStage site this week, so won't be able to post it until I am (need a DataStage client to get at it). I will update this thread once I've done that.

[sheema]

Ray,

I am waiting for the IsValid() function for server Jobs which you promised to post.

Thanks
Sheema

[ray.wurlod]

Sorry about the delay. You can find it here - right-click and Save Target As... to get the DSX file.
Please heed copyright requirements (can be re-used if copyright notice is preserved).

[chulett]

Very nice Uncle Ray.

[sheema]

Thank you for sending the routine ray.

Sheema

[diamondabhi]

Sorry about the delay. You can find it here - right-click and Save Target As... to get the DSX file.
Please heed copyright requirements (can be re-used if copyright notice is preserved).

Ray,
Do you have this function built in C++. Please share it if you can.

Thanks,
Abhishek

[Manfred Hagedorn]

Hello,
i use to check dates with "IsValid" in a Transformer
If IsValid('date',StringToDate(L1.LOANAF_DAT_CRE,"%yyyy%mm%dd")) then ... else ...
Manfred

[Manfred Hagedorn]

sorry, i didn't read the second page of posts
Manfred

[ray.wurlod]

Do you have this function built in C++. Please share it if you can.

I don't.