Derived Column Editor
- by Rob Bowman
Hi
I need to assign a formatted date to a column in a data flow. I have added a Derived Column editor and entered the following expression:
"BBD" + SUBSTRING((DT_WSTR,4)DATEADD("Day",30,GETDATE()),1,4) + SUBSTRING((DT_WSTR,2)DATEADD("Day",30,GETDATE()),6,2) + SUBSTRING((DT_WSTR,2)DATEADD("Day",30,GETDATE()),9,2)
The problem is that the "Derived…