Crystal 11 date range selection 1

[trivalent]

Currently using Crystal 11. Here is the situation. I am trying to write a report that list the clients and calc the the number of day of service in a date range for each client. Clients are admitted into a Program (admit date) and are discharged (discharged date)from the program. I want to be able to enter a date range example 6/1/07 to 6/8/07 and get a listing of all clients that are in the Program in the selected date range and calc the number of day each client is in the Program for that date range. The problem I am having is clients could be admitted before 6/1/07, dischared before 6/8/07 and admitted after6/1/07 and discharged after 6/8/07.

I have tried for several days to resolve this problem. I really dont know programing in Crystal syntax or basic really at all. I am really not sure where to begin or even if this can be done in Crystal. Thanks.

 

[lbass]

Use a record selection formula like:

{table.admitdate} < maximum({?daterange})+1 and
(
isnull({table.dischdate}) or
{table.dischdate} >= minimum({?daterange})
)

Then use a formula like the following for the date difference:

datevar admit := date(0,0,0);
datevar disch := date(0,0,0);
if {table.admitdate} < minimum({?daterange}) then
admit := minimum({?daterange}) else
admit := {table.admitdate};
if isnull({table.dischdate}) or
{table.dischdate} > maximum({?daterange}) then
disch := maximum({?daterange}) else
disch := {table.dischdate};
datediff("d",admit,disch)

-LB