Hi all,
From the source the dates are coming like '1980-02-31','1995-02-31',
'2000-02-31', '2007-02-31' which is invalid because for Febrauary you will never have 31 days.
Can anybody tell me how to validate of the date?
Thanks for your help in this.
how to validate the date in the datastage
Moderators: chulett, rschirm, roy
how to validate the date in the datastage
Thanks and Regards,
Sivasankar.z
+44-07807478984
Sivasankar.z
+44-07807478984
Use IsValid('DATE' , In_Date_Column) in Transformer stage
Last edited by koolnitz on Wed Nov 28, 2007 3:49 am, edited 2 times in total.
Nitin Jain | India
If everything seems to be going well, you have obviously overlooked something.
If everything seems to be going well, you have obviously overlooked something.