Date Format

Can someone please help with this?

I have a standard CSV file with a column that contains a DATE formatted as YYYYMMDD

I have a transformation with a READER to the CSV file and a TRANSFORMER which is basically a 1:1 mapping of fields to a SQL Server table

The DATE column has been defined as 'date' and I have a REFORMAT action to use a format of YYYYMMDD

But during transformation I get the following error for each row. It is like the REFORMAT Action is not being called

In order to load data into "DATE" field, it must be converted into YYYY-MM-DD HH:NN:SS.FFF format.

Although it can be done using Reformat Date Function the prefered way of doing it is to use "Date Format" transformation function.

www.etl-tools.com/wiki/aetle/transformation_functions/date?s []=date&s[]=fields

Same apply to time fields