I have a dt-str coming in from a text file. it is a 6 character date yyyydd. I need the destination to be date yyyy-dd. I tried the code below, but it adds an 01 for the day at the end, making it 8 characters.
(TRIM(YMPPD1) == "") ? NULL(DT_DBDATE) : (DT_DBDATE)(SUBSTRING(YMPPD1,1,4) + "-" + SUBSTRING(YMPPD1,5,2))
I appreciate the help with this.