2 Replies Latest reply: Oct 12, 2011 6:26 PM by Stefan Wühl RSS

    Converting month column with working day into Date and working day columns

      Hello everybody,

       

      I currently have a table with this structure :

       

       

      A Year colmun (JARH), a MON01 column, MON02, .... MON12 colunm

       

      Each MON* column contains the working days of the month

       

      My goal is to get a table with this scruture :  Date / Open ?

       

      For exemple :

      Date - Open

       

      10/10/2011   -  0

      11/10/2011 - 1

       

      Any ideas ?

       

      Regards

       

      Kevin