3 Replies Latest reply on Aug 7, 2016 10:12 PM by Ashish Chaudhari

    Date Difference

    Eshwar Prasad

      Hi Team,

      I Have a requirement like below.

       

      Please help me to get this as it is very urgent for me..

       

      I have data like below..

       

      Memb_ID  Claimkey  admis_Date    Discharge_Date

      100                10001       20-01-2015      30-01-2015

      100                10002       25-02-2015       28-02-2015

      100                10003       15-03-2015        20-03-2015

      200                20001       20-02-2015        27-02-2015

      200                20002       25-03-2015        28-03-2015

      200                20003       15-04-2015        20-04-2015

      200                20004       20-06-2015        30-06-2015

       

       

      I need to get distinct claims count who are rejoined with in 30 Days

       

      But in need to get the difference in dates like below..

       

      if Member is having 3 claims then

      Member's second claim admit date - member's first claim discharge date

      and

      Member's 3rd claim admit date - member's 2nd claim discharge date

       

      Like this i need to calculate how many claims are readmitted. and i need to shoe that claim count in the bar graph across Years..