5 Replies Latest reply: Feb 1, 2017 3:18 PM by Sunny Talwar RSS

    How to convert.change a date format in loading script?

    Jim Chan

      Hi guys,

       

      i am facing a problem.

       

      i have a date field with date like 20160223. now i want to change the datefiled format to 23/2/2016.

       

      my expression is Date#(date([MY_DATE]),'DD/M/YYYY') as [MY_DATE], - but is wrong....

       

      pls help!

       

      Rgds,

       

      jim