Hi,

I tried the following, but it still didn't work when trying to return a date as DD-MM-YYYY. Please see the expression below:

(DT_DBDATE)(DT_WSTR,2)(SUBSTRING(DATE,1,2) + "-" + (DT_WSTR,2)SUBSTRING(DATE,4,2) + "-" + (DT_WSTR,4)SUBSTRING(DATE,7,4))