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!

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

Date/Range Parameters

Status
Not open for further replies.
juspar

juspar

Technical User
Oct 18, 2002
2
0
0
GB
Hello Guys

I am trying to create a report with a date parameter that allows for a range of values and want to display the start and end values of the range parameter. What would be the best method for doing this?
 
Sort by date Sort by votes
You can create formulas that can be used for display of the dates:

@StartDate: ToText(Minimum({?DateRange}),"M/d/yyy")

and

@EndDate: ToText(Maximum({?DateRange}),"M/d/yyy")

use the formula fields in your report where you need them.
 
Upvote 0 Downvote
Just create one formula:

"From "+totext(minimum({?DateRange}))+" to "+totext(maximum({?DateRange}))
Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

D
  • Question
Stored Procedure with no Parameters
Replies
0
Views
154
doodledump
D
rwwagner
  • Locked
  • Question
Passing date range formula from main report to sub report
Replies
2
Views
199
lbass
lbass
PeteyN.O
  • Locked
  • Question
Crystal Report passing a date parameter to a number type field
Replies
3
Views
95
hilfy
hilfy
Mark.rooker
  • Locked
  • Question
Find closest date
Replies
1
Views
92
lbass
lbass
hpl2001
  • Locked
  • Question
Calculating totals across a date range
Replies
10
Views
167
hpl2001
hpl2001

Part and Inventory Search

Sponsor

Back
Top