How to convert date format dd.mm.yy into yyyymmdd?

Hi Axel,

You can do this in the transfer rules using a conversion routine. Goto transfer rules -> Transfer str/Data structure -> for the date field -> select the conversion "PDATE" and then try the load.

If the above solution did not work then then you need to use transfer routine. The routine would be like this:

Char v_date(8), i_date(8), day(2), month(2), year(2).
i_date = trans_stru-<your date>.
day = i_date +  0(2).
month = i_date + 4(2).
year = i_date + 7(2) + 2000.
concatenate year month day into v_date.
Result = v_date.

Bye

Dinesh

(Do not forget to assign points!!)