Showing date parameter 2

[Saint1234]

Hi all,
I am using crystals parameters. I was wondering I have it setup to select data within a date range. How can I show this range on the report? Thanks in advance.
G

 

[vidru]

Try this formula:

"Date Range: " + ToText(minimum({?DateRange}), "MM/dd/yyyy") + ' to ' + ToText(maximum({?DateRange}), "MM/dd/yyyy")

-dave

 

[BobSuruncle]

You could create a formula similar to the following:

"Date Range is from "
& Minimum({?YourDateRangeParameter})
& " to "
& Maximum({?YourDateRangeParameter})

This will show the dates in a default format.
If you wish to modify the formatting of the dates, then use ToText or CStr to give the date whatever formatting you wish.

eg

"Date Range is from "
& ToText( Minimum({?YourDateRangeParameter}), "MMM-dd-yyyy")
& " to "
& ToText( Maximum({?YourDateRangeParameter}), "MMM-dd-yyyy")

HTH


Bob Suruncle