5 Replies Latest reply: May 15, 2017 4:33 AM by Bijay Jha RSS

    Text to date format in script

    Bijay Jha

      Hi ,

       

      Can anyone help me in getting the year?

      I tried the below script but it not working ... 

       

      ABC:

      LOAD Date#(Date)as Date,,

                Year(Date#(Date)) as year,  

                Name,      

                Product,      

      Sales FROM CORE_DUP\123.txt (txt, codepage is 1252, embedded labels, delimiter is '\t', msq);