1 2 Previous Next 20 Replies Latest reply on Mar 9, 2018 11:27 AM by Deepak Rai

    convert string into date from Netezza data source

    Kahv Jiv

      HI,

       

      I have a field in my Netezza data source that has information about month-year. But this field has data type as string.

       

      Financial_period

      201601

      201602

      201703

       

      I have to convert this field into the date field. but since it is Netezza data source, I dont have makedate or dateparse function.

      I also tryed creating a calc field

      DATE(LEFT([Financial_period],4)+ '-'+RIGHT([Financial_period],2)) but it gives me below error msg. How do i do it..?

       

      thanks!

        1 2 Previous Next