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

[vbahelp07]

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!

 

[raja2008]

you can use inimum and maximum functions on the daterange.


minimum(daterange?)

 

[vbahelp07]

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.

 

[vbahelp07]

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

i don't get where and how to use / apply minimum{?Invoice Date Range}?

 

[vbahelp07]

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}

 

[raja2008]

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.

 

[vbahelp07]

i did this

formula = minimum{?Invoice Date Range}

and when i do an error check it gets an error

 

[Charliy]

create a formula something like this:

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

 

[vbahelp07]

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!

 

[lbass]

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

 

[vbahelp07]

syntax ... makes a difference for sure