Date range-pulling last date formula

[cmhdover]

I have a report of hospital bed days - each client has a start date and an end date (unless they are still in the hospital). I need a report that shows monthly total of bed days -

I have a parameter for the user to enter the date range (they will use 12/1/04 - 12/31/04 for example).

The problem is I get all the clients who were admitted in December, but also the ones who were admitted in December but released in January. I want to calculate their total number of bed days for that month - not crossing over to the next.

I'm not quite sure what to do.........would appreciate your help!

Thanks,
Dennielle

 

[pgtek]

hi
create a running total and select on change of patient

cheers

pg

pgtek

 

[lbass]

Try using a calculation something like:

if isnull({table.enddate}) or
{table.enddate} > maximum({?daterange}) then
datediff("d",{table.startdate},maximum({?daterange}) else
datediff("d",{table.startdate},{table.enddate})

-LB

 

[cmhdover]

Thank you lbass - you are awesome!

I appreciate your help!!!

Dennielle