title: Informatica Converting string to date
body: <p>i'm trying to convert a string date from a flat file to a Date data type. what i did is create a new conv out port and use TO_Date ( Field name , 'YYYY/MM/DD') and i'm getting an error .....
  this is the error message btw this the date i'm getting from the late file .... </p>
  
  <p>" Severity Timestamp   Node    Thread  Message Code    Message
  ERROR   3/17/2014 4:18:01 PM    node01_t41-ccc-03   TRANSF_1_1_1    TE_7007 Transformation Evaluation Error [&lt;> [TO_DATE]: invalid string for converting to Date
  ... t:TO_DATE(s:'          ',s:'YYYY/MM/DD HH:MI:SS')] " please help ....</p>
  
  <p>Sam </p>