23 Replies Latest reply: Jun 13, 2015 2:51 PM by Marco Wedel RSS

    Converting string to Date 'DDMMYY' format

      Hi,

       

      I have loaded a series of dates below.

       

      LOAD

          Sales Agent,

          "42158",

          "42165",

          "42172",

          "42179",

          "42186",

          "42193",

          "42200",

          "42207",

          "42214"

       

      How can I convert them into DDMMYY format? I've seen a few suggestions online but wasn't able to get it working... thanks for your help!