DateTime Parameter only ask Date

[Crewdawg]

I have report in which rows are selected by a DateTime Parameter. I only want the parameter to ask for the Date since the time should always be assumed to be 00:00 (Midnight) for the start date and 2359 (11:59 PM) for the end date in this report.

How do I convince Crystal to only ask the date or force it to assume the above times and still remain transparent to the user.

I am using Crystal Reports 10 with a SQL2000 DB via ODBC.

----------------------------------------
Multithreading is just one thing after, before, or simultaneous with another.

 

[lbass]

I think you can change the parameter to a date parameter. If you are using a range, you can set up the record selection like:

{table.datetime} = {?daterange}

In the parameter selection screen, you could choose the day after the desired end date, and check "do not include end date" (if this is available in CR 10).

If your parameter is not a range parameter, use two date parms, and set them up like:

{table.datetime} >= {?startdate} and
{table.datetime} < {?enddate}+1

-LB

 

[Crewdawg]

It appears that I must setup the parameters as datetime for the selection expert to allow the parameters to pass. Once setup I can change the parameter type and it will work flawlessly. Thanks again lbass you're always a tremendous help.

-Sean H
----------------------------------------
Multithreading is just one thing after, before, or simultaneous with another.