(DT_DBDATE)(SUBSTRING(ActualShipDate,1,4) + "-" + SUBSTRING(ActualShipDate,6,2) + "-" + SUBSTRING(ActualShipDate,9,2))

This is for a date that comes in the following format

2011.01.13 00:00:00

It gets converted to DataType_DBDATE

2011-01-13