DSXchange

I have an integer source(AS400) field which I need to convert into DB2UDB date field.
The value of the field is like this 060526(yymmdd). Please let me know the best way to do it.

Thanks in advance.
Abhi.

How about this?

Hi,

First put your integer in a string field in a stage variable and convert that function into date by using StringToDate function as in the link suggested by Dsguru2B.