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

Crystal Date Time Parameter

Status
Not open for further replies.

GCL2007

IS-IT--Management
Dec 11, 2007
167
US
Using Crystal Reports XI, am looking to use a parameter with a Date Time type. I'd like to set it up as a From-To parameter and would like to have the From time default to 00:00 and the To time to default to 23:59. The report is currently using just a date parameter and they want to add the time aspect to further narrow their parameter scope. Any good way of doing this? Thanks
 
Change the parameter type from a date to datetime. You can than add defaults to the parameter to return the desired time when first opened. Make sure you set 'allow range value' to true..

Then place that in your select statement

{?yourparameter} in {yourdatetimefield}
 
Thanks BlurredVision,
That would work, but in my case, I'd want the default Starting time to be 00:00 (or something like that) and the ending time to be 23:59 to get the whole day. I think I'd want the starting default to be different from the ending default - wasn't sure if I could do this with one parameter.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top