Display text if a certain parameter is met 1

[kcoleman26]

Crystal 2008

I have a formula for the date range parameter {Date Range Title} that I am displaying in the report header.

"From: " & Minimum ( {?Date} ) &
" To: " & Maximum ( {?Date} )

Now what I am stuck on is when the Min & Max date meet a specific critiera I want to display the text "All Dates Selected"
The dates are min 1/1/1950 and max 12/31/2050. In my paramerter I have these two dates defined as the Start and End dates for that parameter.

So end result would be if any other dates are selected show those dates. If the min = 1/1/1950 and the max = 12/31/2050 then display "All Dates Selected" in the header.

Thanks,
KC

 

[fisheromacse]

maybe a change like this?


IF Minimum ( {?Date} )= "1/1/1950" AND Maximum ( {?Date} ) = "12/31/2050"
THEN "All Dates Selected"
ELSE
"From: " & Minimum ( {?Date} ) &
" To: " & Maximum ( {?Date} )

 

[records333]

I have a smiliar goal:

I have a group by location that captures patients' newly diagnosed date with 250.**. I would like to capture the minimum date for each patient as mulitiple dates are referenced due to multiple dx. Any tips.

 

[Charliy]

333- if your report contains only those patients with a 250 dx, then all you need is a formula that's like:
Minimum({dxdate},{group field})

If it contains patients without the 250 dx then you could use a Running Total
Field to Summarize - {dx date}
Reset on - your group
Type of Summary - Minimum
Evaluate - Use a formula - Formula: left({icd9code},3) = '250'