title: Converting String to Date using T-map with Talend Open Studio
body: <p>I'm having trouble converting a couple of sting fields to date with Talend Open Studio.  All date fields are coming to me via csv in the format "MM/dd/yyyy hh:mm:ss aa"  For example "03/20/2018 2:40:03 PM"  </p>
  
  <p>Many date fields are fine, and conversion with the t-map component and the talend.date (parse date) is working as it should.   The problem occurs in two fields where many almost all of the dates are coming in as "12/30/1899 00:00:00 AM"</p>
  
  <p>I'm using the tmap to push the file to a toutputdelimited (CSV).  The format of the fields with "12/30/1899 00:00:00 AM" is coming back as "#######################." Any ideas on how to handle the situation would be great.  The output date format is "yyyy-MM-dd HH:mm:ss"  </p>
  
  <p>Again, all other fields are converting as they should.  Its only the special case "12/30/1899 00:00:00 AM" that is causing problems.</p>
  
  <p>Thans!</p>