Special date range in Crystal 1

[lana123]

Hi, people.
I created "OccurrenceDate" parameter with default equal to"01/01/2006".It works:

if minimum({?OccurrenceDate}) <> Date(2006,1,1) then
{CLAIM.LOSS_DATE} = {?OccurrenceDate}
else if minimum({?OccurrenceDate}) = Date(2006,1,1) then
true

I have to print the report with the title:
"Occurrence Date, Years 99-03" (the years 1999 and 2003 are specified in parameter From,To sections)
I try to find out which functions I need use to put into Report Title parameter's range but I cannot do it.
I'll appreciate any help.
thanks

Lana

 

[synapsevampire]

You pretty much had it:

if minimum({?OccurrenceDate}) <> Date(2006,1,1) then
"From "+ totext(minimum({?OccurrenceDate}) +" to "+maximum({?OccurrenceDate})
else if minimum({?OccurrenceDate}) = Date(2006,1,1) then
"No range specified"

-k

 

[lana123]

It's great formula but I cannot run it in formula editor
(I tried several variation but it gives me different error messages)
thanks,

Lana

 

[synapsevampire]

Try posting what you tried and the error, saying it doesn't work and it returns an error doesn't help.

I had assumed that this was a date range parameter, not 2 seperate parameters.

This is also dependent upon the version of Crystal, your posts leave everything to the imagination, a little more effort would help everyone involved.

-k