[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 315
  • Last Modified:

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
0
Clif
Asked:
Clif
  • 3
1 Solution
 
Kurt ReinhardtSr. 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

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now