Date Parameters

[kristinaloupe]

Does someone know......What is the formula I would use to display the dates I choose in the parameter for the report header?

The join functions works only on strings.

Thanks,
Kristina

 

[vidru]

Try:

"From: " + ToText(Minimum({?DateRange}), "dd/MM/yyyy")) + " to " + ToText(Maximum({?DateRange}), "dd/MM/yyyy"))

-dave

 

[kristinaloupe]

Thanks.. but this didn't work.

 

[kristinaloupe]

But.. this did... giving me "From: 3/1/2005 to 4/12/2005"

"From: " + ToText(Minimum({?Between What Dates?})) + " to " + ToText(Maximum({?Between What Dates?}))

Thanks for the tip .. got me going!

Kris