Parameter Help

[ecugrad]

I'm a new Crystal user and any help would be appreciated.
I have three fields UserName, LoanAcctNo and EndTime. I'm tring to set up a parameter that will select all userNames and LoanAcctNo Where the Endtime is between <Entered or selected datetime>and<Entered or selected datetime> for some reason I can't get this to work..

Thanks for any help,

Mike

 

[kenhamady]

What is the data type of the field: &quot;endTime&quot; as seen by CR. (Browse the field to confirm if it is a date, dateTime or a String.

What version of CR?
What parameters do you have? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[ecugrad]

Ken, thanks for the reply I figured out one of my problems on using parameters. I do have another question for you. I'm building my parameter on a datetime field(EndDate). This allows the user to select a range of dates in this field and display the data between the two selected date ranges. What I rally need is the Start Range to always be todays datetime Ex: 4/18/01 12:01 AM and let the user selected the End Range datetime. I have searched the board and haven't found anything on the topic. I am using CR8. Any help would be greatly appreciated..

Thanks,
Mike

 

[kenhamady]

You will have to edit the selection formula to be:

{field} in CurrentDateTime to {?endparam} Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)