[Peter Gulka]

OK, so I have created a DateTime parameter tha captures a range of dates. Is there a way to display in the report the two values stored in this parameter? Is it an array?

Man, I suck at this stuff...

[Dan Larson]

Maybe the Join() function would work for you. Something like Join({?MyDateRangeParam},", ")

But then it would be on the same line, I don't know if you'd want that.

[Peter Gulka]

Error

"A string array is required here"

[Dan Larson]

Oh yeah - you'll need to convert the datetime to a string.

I think it's the CStr() function.

[DrewAllen]

It's a range, not an array. You can use the Min() and Max() functions with the range to find the start and end points and then combine them however you want.

Drew

[stancliff]

Quote:

Originally Posted by DrewAllen

It's a range, not an array. You can use the Min() and Max() functions with the range to find the start and end points and then combine them however you want.

Drew

I concur with Drew. I used the min() and max() functions last week for the first time. You can also use the HasLowerBound() and HasUpperBound() functions to test to see if the parameter was supplied with a min() and max() value.

Here is a snippet of code as an example.

//has both start date and end date...
//...and start date is 1 - 9 and end date 10 - 31
...else if ( HasLowerBound({?Gift Date}) and HasUpperBound({?Gift Date})
and day(minimum({?Gift Date})) < 10 and day(maximum({?Gift Date})) >= 10 )
then chr(13) + totext(minimum({?Gift Date}), "MMMMd, yyyy") + " through " +
totext(maximum({?Gift Date}), "MMMM d, yyyy")...

[Peter Gulka]

I love you guys. It worked perfectly!