8 Replies Latest reply: Feb 17, 2015 4:26 PM by Rupesh Bharadwaj RSS

    How to replace the one date by another date and a number also?

    kvp kumar

      Hi  friends,

       

      i am  having the data as

      id  name date1       date2

      0    A      1/1/2000  1/3/2010

      1   A       2/1/2000  2/4/2010

      2  B       3/1/2000     2/5/2010

      3   c       3/1/2000     2/6/2010

      4   c       4/1/2000     2/7/2010

       

      In the above table , name  'A' as two rows as id=0,id=1 then in this i want to take the id = '1' and i also want to take minimum date of these two name

      It should be like these:

      id name date1 date2

      1 A      1/1/2000   2/4/2010

      2  B       3/1/2000     2/5/2010

      3   c       3/1/2000     2/6/2010

      4   c       4/1/2000     2/7/2010

      can any help me,

      I tried many thing but i am not both things , but only i am getting only one of these.

       

       

      Thanks in advance

      Kumar