Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calculate date difference for dates on 2 different lines of detail

Status
Not open for further replies.

vicj

Technical User
Jul 19, 2001
1
US
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!


 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top