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

Forcing a date parameter value to TODAY[b/]

Status
Not open for further replies.

ramc2000

Technical User
Nov 8, 2002
60
GT
Hello all, I'm using a date parameter range value in my report, I can let the user pick whatever start date they wish but I need to force the end date to always be TODAY, does anyone know how to do this?? or perharps there's a better approach than using a date range value?? thank you.
 
Create a single-value date parameter for the start time.

In the record selection criterion specify currentdate as the end point.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
 
Thank you, this worked. THis is how the selection criteria looks:

{dateField} >= {?Pm-?StardDate} and
{dateField} <= CurrentDate
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top