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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Create a Date Range

Status
Not open for further replies.

Gizmo0917

Technical User
Dec 5, 2003
43
US
I have a report. I created to Formula Fields SDate (Feeding off ChartDate) and EDate (Feeding off ChartDate); I would like to have my report ask the user to enter a date range using these to formula fields so I know that it is pulling from the correct date fields. How do I do this? I used to know but it has been a while since I used Crystal.

Please Help!

Giz
 
Create two parameter fields:

?StartDate
?EndDate

In the Select Expert, select your ChartDate database field.
in the pulldown, select "Is Between" and then for the first
item, select {?StartDate} and for the second select {?EndDate}

This is how you get Crystal to prompt for the parameters.

Hope that helps.

Tom
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top