Calculate date difference for dates on 2 different lines of detail

[vicj]

I need to calculate the dates a patient is "out" of the facility. Each line of detail has a UID that is unique to that line. Here's the data:

Patient # UID Admission Date Dismissal Date
1234 44 08/01/2015 08/31/2015
1234 104 09/24/2015 09/29/2015

I need to calculate the difference between 08/31/2015 & 09/24/2015. Thank you in advance for your help!

 

[Charliy]

You can use either NEXT or PREVIOUS depending on which line you need the result on.

NEXT({table.admission_date}) - {table.dismissal_date}

or

{table.admission_date}) - PREVIOUS({table.dismissal_date})

with either one be sure you're testing to see that you're still on the same patient.