Show a title like "{first date} to {last date}" refering to dates in the report 1

[freakygreeneyes]

Hi Fellows

I just started using crystal reports and am really not familiar with it jet. I've already programmed in VBA and therefore I prefer the Basic-Syntax but I should also be able to handle a Crystal-Syntax Solution.
My target:
I want to set a title in a report that says whats the date of the first list entry to the date of the last list entry. The dates are measured as data base fields.
If possible it would be great, if the "last date" part could be changed via parameters into any choosen date.
Thanks a lot for your help!
Greets
freakygreeneyes

 

[xxyyzz49]

Might try the MAXIMUM and MINIMUM functions in separate formulas. Two examples:"

//formula @FirstDate
minimum({database date})

//formula @LastDate
maximum({database date})

 

[freakygreeneyes]

Hey pmsawyer

Thanks a lot, that works perfect for me!
Two more questions:
1. How do I format the so shown dates? (Their now shown like "dd.MMMM.JJ 00:00:00" but I only need the date, not the hour.
2. Is it possible to modify the @LastDate Formula, so you could choose to eighter show the last date or one you enter yourself?

Thanks a lot!
Greets

 

[freakygreeneyes]

Hey again!

I solved it myself.
Here you go:

If {?DateParameter} > maximum ({DatabaseDate})
Then " Vom "+toText(minimum({DatabaseDate}), "dd. MMMM yyyy")+"  bis  "+ToText(maximum({DatabaseDate}), "dd. MMMM yyyy")
Else " Vom "+toText(minimum({DatabaseDate}), "dd. MMMM yyyy")+"  bis  "+ToText({?DateParameter}, "dd. MMMM yyyy")

Maybe its helpful for someone else.

Greets