Date Reformat? Am I missing something.

I am trying to reformat the date from the text file to a sql format date. Seems simple enough but I am missing it.

Are you loading data into Date or Datetime field?

Please try using
M/D/YYYY HH:NN:SS TT format

Datetime

If you are loading data into datetime field you have to make sure that your data is in standard ODBC format YYYY-MM-DD HH:NN:SS.FFF
You can use Date format function for it
www.etl-tools.com/wiki/aetle:transformation_functions:date?s []=format&s[]=date
If it is already in this format just leave as it is
Do not forget to get rid of leading and trailing spaces

It's just a text file and I am trying to send to a SQL table datetime. i tried setting the SQL to date, not luck. I also tried a trim as suggested.