Please help! problems writing datatime parameter

[gogo8]

I have database Datetime field look like the following:
Arrive time: 3/26/2002 10:05:47 AM.

I need to set parameters so that if my manager selects any date from the list ie. 3/25/2002 then the all the datas that created on 3/25/2002 should come up in the report.

Here are what I did so far:
Parameter1 called "Begin_Date" with Datetime as value type.
and range limit from 1/1/2002 7:00:00AM
to 12/1/2002 7:00:00PM
Parameter2 called "End_Date" with same setup as above. (Since it is datetime type, it automatically comes up with hr,min,sec. I choose range type because sometimes I need a report on monthly basis, ie. 3/1/2002-3/31/2002)

Then from the select Expect, I have the following formula:
(Arrive time)=(?Begin_Date) and (Arrive time)=(?End_Date).
But no matter what date I choose, it comes up 0 or blank record report!!!

I am very new in crystal report so please show me with detail instructions how to solve my problems.Thanks very much!

 

[Roadkill150]

Try:
(Arrive time) in {?Begin_Date} to {?End_Date} Seagate Certified RCAD Specialist.
-Bruce Thuel-Chassaigne
roadkill150@hotmail.com

 

[gogo8]

Thanks..
I tried your formula but I got this error message "A number, currency amount,date, time, data-time or string is required here".

 

[Roadkill150]

I just re-read your post. you are using dual range parameters, so the solution i gave would not work.
if you want to see all records between the two dates, just use a single parameter with a date range and set the formula to: {@Arrive time} = {?Begin_Date} this will return all records within the date range specified
Seagate Certified RCAD Specialist.
-Bruce Thuel-Chassaigne
roadkill150@hotmail.com

 

[gogo8]

I tried one parameter method before still gives me blank report. I think maybe the time causing the problmes, not the date!!

 

[Roadkill150]

To test this, in the report designer, select File, then report options, at the top select convert date time to Date, next check your parameter field, make sure the parameter is also set as a date type (not date time) then try running the report again and see if data returns. Seagate Certified RCAD Specialist.
-Bruce Thuel-Chassaigne
roadkill150@hotmail.com

 

[gogo8]

It is working! Thank you very much for your help!