2 Replies Latest reply: Sep 30, 2014 5:03 PM by vspr n RSS

    How to Concatenate 2 or more columns to create a listbox

    vspr n

      Hi Everyone,

      I have a requirement where in provided with MONTH, DAY AND YEAR as separate columns create a list box concatenating all 3 columns.

       

      INPUT:

      MONTH     DAY     YEAR

      JAN           02        2013

       

      DESIRED OUTPUT:

      DATE_COLUMN

      2013-JAN-02

       

       

      Thanks in Advance!