Readmissions with in 7 days of discharge

[torolimon]

I am trying to find a way to display a readmit date for patients that is less than 7 days from admit date.

The fields I’m working with are {Discharge.Effective Time} and {Admit.Effective Time} . I also a group on {Patient.MRN}. Every thing I try keeps bringing up the same dates multiple times.

 

[Turkbear]

Hi,
Are those 2 fields Dates or DateTime?

Are new records created on re-admittance?

Neither of those fields seems to have a readmit date or time.


BTW, what have you tried and what do you mean by 'same dates multiple times'?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Madawc]

Try doing a formula field with DateDiff. Start off displaying it, to check you're getting the results you want. Then use for selection.

If the dates are on multiple records, group and do a summary total for Maximum. Do the calculation in these maximum values.

If you're not already familiar with Crystal's automated totals, see FAQ767-6524.


Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[torolimon]

Are those 2 fields Dates or DateTime? They are Datetime fields.

Are new records created on re-admittance? Yes, they each have a new {Patient.CSN} for each admit.

Neither of those fields seems to have a readmit date or time.
There is no readmit field in our tables.


BTW, what have you tried and what do you mean by 'same dates multiple times'?

I've tried putting the {Discharge.Effective Time} and {Admit.Effective Time} on the same detail line and suppress any duplicates. We have a ADT table that holds all the admit, discharge, and transfer data. I link a copy of the ADT(ADT_ADMIT) table with ADT.ADM_EVENT_ID to ADT_ADMIT.EVENT_ID and then the ADT table to another copy of the ADT(ADT_DISCHARGE) table with ADT.DISCHARGE_EVENT_ID to the ADT_DISCHARGE.EVENT_ID.
MRN #
1111111 Discharge Time Discharge CSN Admit Time Admit CSN DateDiff
1111111 1/16/09 15:19 66666666 1/13/09 21:46 66666666 2.75
1111111 2/28/09 13:55 77777777 2/24/09 15:25 77777777 3.92
1111111 4/30/09 11:44 88888888 4/28/09 14:35 88888888 1.88
1111111 5/29/09 10:30 99999999 5/26/09 15:20 33333333 2.79
1111111 6/18/09 18:29 44444444 6/16/09 17:51 55555555 2.04
1111111 6/25/09 11:00 22222222 6/19/09 15:29 22222222 5.83

 

[lbass]

Based on your sample data, what would you like your report to display?

-LB

 

[torolimon]

I actually figured it out. The problem was in the linking of the different tables. I needed to add a second link of a DATE_REAL field on each table.