13 Replies Latest reply on Jan 14, 2019 4:49 AM by Nico Heinze

    Convert Date Timestamp to Date for Salesforce.com

    Stacey McDonald New Member

      Here are some example values from the source flat file:

       

      12/21/1982 0:00

      6/28/1984 0:00

      8/1/2016 0:00

      10/19/1977 0:00

      10/15/1982 0:00

      8/30/1983 0:00

      1/19/2012 0:00

      2/4/1981 0:00

      5/29/1986 0:00

      2/4/1981 0:00

       

      It's going into a Salesforce.com field with a type of Date. The field type on the source field is datetime. I need to know the expression to convert it for loading into Salesforce.com

       

      Thanks,

       

      Stacey McDonald