5 Replies Latest reply on Jan 31, 2016 9:46 PM by shripad nadiger

    Converting String into Date

    shripad nadiger

      Hi All,

      I need to convert the 'Month' field that's in the string format '2015/01' i.e 'Year/Month' to date format.

      I tried to change the data type to 'Date' but gives a random number 4714.

      Capture2.JPG

      The data source here is Teradata.

       

      I have tried converting string to date on previous occasions with the same format and it has worked perfectly fine though the data source in this case is an excel file.

      Capture1.JPG

       

      Not able to understand , what am I missing in the first case.

       

       

      Thanks and Regards,

      Shripad Nadiger