12 Replies Latest reply: Mar 12, 2015 6:21 AM by søren schou RSS

    convert date in script help

      Hi

       

      Suddenly one of my datafields(which I cant change myself)is altered from showing the dateformat as

      dd-mm-yyyy to showing my date as yyyy-mm-dd-hh-mm-ss-sssssssssssss

       

      Please help to make it as dd-mm-yyyy

       

      Something like

      load

      [DATE],

      LEFT([DATE],10)dd-mm-yyyy as DATE