Displaying a Date Range from Parameter Fields

I know how to display a string value from a Parameter Field.  I have learned how to display a list of items if the parameter field is "Allow Multiple Values".  However, I cannot seem to be able to display the range (start date and end date) in the parameter field.

How do I do this?

TIA
LVL 10
ClifAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Kurt ReinhardtConnect With a Mentor Sr. Business Intelligence Consultant/ArchitectCommented:
If you're referring to a simple ranged date parameter, you can create formulas for the minimum and maximum values.

Minimum({?Date})

Maximum({?Date})

If you're referring to a ranged date parameter with multiple ranges, it gets a lot more complicated...

~Kurt
0
 
ClifAuthor Commented:
Error: "The formula result must be a string."

Tried changing it to read:

ToText(Minimum({?Date}))

Result is empty.
0
 
ClifAuthor Commented:
It is not multiple ranges.  Just a range.  I enter values for "Start of Range" and "End of Range"
0
 
ClifAuthor Commented:
Not sure what the problem was.  I tried adding the code to the Parameter Field's "Display String" code behind, like I had done for other Parameter Fields and it didn't work.

However, just for grins and giggles I tried just creating a formula with your code and that did work.

Thanks for the help.  :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.