how to validate date function in datastage?

[balaya.ds]

how to implement the below rule in Datastage?

i have a column "TransDate" the datatype is char and format is yyyymmdd

yyyy should be start with "20"

mm shd be value 01 through 12.

[swathi Singamareddygari]

Try using below logic

StgVardate=TransDate[1,4]:'-':TransDate[5,2]:'-':TransDate[7,2]

In another stage varible give the derivation like this

If StgVardate[1,2]='20' And IsValid('date',StgVardate) Then 'Valid' Else 'Invalid'

[HariK]

how to implement the below rule in Datastage?

i have a column "TransDate" the datatype is char and format is yyyymmdd

yyyy should be start with "20"

mm shd be value 01 through 12.

what is your source?
If it is a database use database function to convert into date and check if the date is greater than 31-dec-1999
If sequential file Swathi's reply will help.