crystal formula 1

[p658484]

Hello,
I would like a formula to extract the following information

1.admission April 1 discharge April 14
2.admission April 14 discharge April 25

The formula should excluded the cases when 1. discharge date = 2. admission date.

Thanks

 

[lbass]

You would have to use a section suppression formula like this:

(
not onlastrecord and
{table.groupfield} = next({table.groupfield}) and
{table.dischargedate} = next({table.admissiondate})
) or
(
not onfirstrecord and
{table.groupfield} = previous({table.groupfield}) and
{table.admissiondate} = previous({table.dischargedate})
)

I added in the group clauses, as I assumed you might be doing this within a group, e.g., on patientID.

-LB