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

    convert date in script help



      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



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