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!