Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to display the start and end date from a date range parameter?

Status
Not open for further replies.

vbahelp07

Technical User
Oct 16, 2007
115
US
Hello,
I am using CRW v10.

I cannot figure out how to show the first and last date of the date range the user inputs to show on the report.


The report needs to show the range the data is for based on what the user enters in the date range parameter prompt.


thank you!
 
you can use inimum and maximum functions on the daterange.


minimum(daterange?)
 
yes, but how do you mean? where and how?

on the Select Expert?
or just put minimum(?Invoice Date Range) and maximum (?Invoice Date Range)?

In Select Expert I have InvoiceDate equal to {?Invoice Date Range}

which prompts the user to enter the Start and End dates.

 
{AR_InvoiceHistoryHeader.InvoiceDate} = {?Invoice Date Range}

i don't get where and how to use / apply minimum{?Invoice Date Range}?
 
i did this in the Formula and it's not working.
so I really don't know how to apply and where to make this work.

formula = minimum{?Invoice Date Range} "& " maximum{?Invoice Date Range}

or formula = minimum{?Invoice Date Range}
 
what exactly are you trying to display and where
you have to have formulas :

formula 1: minimum(daterange) and place it where you want to see it like in reportheader.
same way with maximum.
 
i did this

Code:
formula = minimum{?Invoice Date Range}

and when i do an error check it gets an error
 
create a formula something like this:

"For the Period "&minimum({?DateRange}) &" thru " &maximum({?DateRange})
 
thank you!


this worked:

Formula = minimum({?Invoice Date Range})" thru " maximum({?Invoice Date Range})


Check Errors said No Errors. Applied to report and it's all working!


Thanks again!
 
You are using basic syntax, while the other posters chose to use Crystal syntax, an option in the formula editor. I think you must have left out the plus or ampersand signs though in your last post.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top