4 Replies Latest reply on Dec 17, 2017 11:29 PM by komal Basava

    Combing two date fields into Single Date Field

    komal Basava

      Hi Guys,

      I have to combine two date fields into one date field.

      Can you help me how formulate this one.

       

      Input:

      Id  salesdate    new sales date

      1    11/01/12    14/12/2016

      2    12/02/13     14/11/2017

      3     6/07/15      18/10/2017

       

       

      OUTPUT:

      Id  Date

      1  11/01/12

           14/12/2016

      2   12/02/13

           14/11/2017

      3    6/07/15

           18/10/2017