3 Replies Latest reply on Mar 7, 2019 6:30 AM by Srini Veeravalli

    Keep getting this error TT_11132 Transformation [Expression] had an error evaluating output column [Run_Date1]. Error message is [<<Expression Error>> [TO_DATE]: invalid string for converting to Date ... t:TO_DATE(u:'20190304',u:'MM/DD/YYYY HH24:MI:SS')].

    Antonio Robles New Member

      Hi

       

      I keep getting this error below

      TT_11132 Transformation [Expression] had an error evaluating output column [Run_Date1]. Error message is [<<Expression Error>> [TO_DATE]: invalid string for converting to Date ... t:TO_DATE(u:'20190304',u:'MM/DD/YYYY HH24:MI:SS')]. 

       

      but my function doesn't include a 'MM/DD/YYYY HH24:MI:SS'. Here is my function for reference.

       

      TO_DATE(TO_CHAR(to_date(RUN_DATE),'mmddyyyy'),'mm/dd/yyyy')

       

      Please Help

       

      Thank you