8 Replies Latest reply on Nov 27, 2018 12:12 PM by Matt Huff Branched to a new discussion.

    Difference in date from different rows

    Matt Huff

      I am trying to create a calculation that shows the difference in days from when one patient admits/discharges to the next time they admit.  In the screenshot, you can see a patient has two different visitIDs with one medical record number.  I want to find the difference from the discharge date of the first visit to the admit date of the second visit.  (All personal information has been changed).  If they have 3 or more visits I would want to continue calculating the time in between each visit from discharge to admit. 

       

      Thanks in advance!