Solved

Displaying a Date Range from Parameter Fields

Posted on 2011-03-03
4
307 Views
Last Modified: 2012-05-11
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
Comment
Question by:Clif
  • 3
4 Comments
 
LVL 26

Accepted Solution

by:
Kurt Reinhardt earned 500 total points
ID: 35029086
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
 
LVL 10

Author Comment

by:Clif
ID: 35029535
Error: "The formula result must be a string."

Tried changing it to read:

ToText(Minimum({?Date}))

Result is empty.
0
 
LVL 10

Author Comment

by:Clif
ID: 35029544
It is not multiple ranges.  Just a range.  I enter values for "Start of Range" and "End of Range"
0
 
LVL 10

Author Closing Comment

by:Clif
ID: 35029739
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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question