date format issue

[times29]

Hi,
My date is in varchar 8 format like 20010431
when i do conversion its coming as 4444-01-01 any idea what can be wrong

Note: some dates are coming good but above conversion have issue


EMP_START_DT_ORIGINAL:20010431

IF IsValid("date", to_transf.EMP_START_DT_ORIGINAL, "%yyyy%mm%dd")
THEN StringToDate(to_transf.EMP_START_DT_ORIGINAL,"%yyyy%mm%dd")
ELSE StringToDate("44440101","%yyyy%mm%dd")

EMP_START_DT_after_ORIGINAL:4444-01-01

[BradMiller]

In your Else statement, you are setting the date to 4444-01-01. The input date is not valid. There are only 30 days in April. It is working as you designed it.

[prasson_ibm]

IsValid("date", to_transf.EMP_START_DT_ORIGINAL, "%yyyy%mm%dd")=1

Put this in transformer constraint to output link and draw another link as reject from transformer and make constraint condition as "Otherwise".

If your input records are not in valid date format it will go to reject link.