6 Replies Latest reply: Nov 7, 2015 5:53 AM by Cédric NANA RSS

    How can I create field  from multiple dates ?

      Hi all,

       

      I have 5 dates. DATE_1 .. DATE_7.

      I want to create field like that contains 12467

      IF DATE_1 NOT NULL 1

      IF DATE_2 NOT NULL 2

      IF DATE_4 NOT NULL 4

      IF DATE_6 NOT NULL 6

      IF DATE_7 NOT NULL 7


      Exemple :

      STORE_ID , DATE_1, DATE_2, DATE_4, DATE_6, DATE_7

      XXXX, 12/04/2015, 14/05/2015,,18/06/2015,23/06/2015

       

      I want to create field STORE_STATE that contains 4 values : 1267

       

       

      53662LT001,16/12/2015,06/10/2015,,,  : the field state_store contains 12

       

      Thank you for your help.

       

      Regards,