If all the input dates are valid dates in the format DMY then use a derived column as you stated but cast the input to date (proving your output table is expecting this)
Try something like
(DT_DBDATE)[Column 0]
in the expression for the derived column
Far away is close at hand in the images of elsewhere.
Anon.