DateTime Parameter Problem CR7

[bKube]

Useing CR7, VB6, Access 2000
I'm trying to set up three Parameters and Select Expert, I have no problem with the Type. One is for a Date field & second for Time, which are being storied seperately. I get a error in the Record Selection Formula "A date-time is required here" just prior to the {?Sales Time}.

The following is my Record Selection Formula:

{tblSales.txtBusiness} = {?Business} and
not ({@owner} like "&quot and
{tblProceeding.dtmProcDate} = {?Sales Date} and
{tblProceeding.txtProcType} = {?Sales Type} and
{tblProceeding.dtmProcTime} = {?Sales Time}

I'm fairly new user of CR, and have gotten a lot of help from reading post here, but haven't found anything about DateTime questions/problems. I thought this was going to be easy.

 

[kenhamady]

Is the field {tblProceeding.dtmProcTime} a DateTime field? That might be why they named it dtm. Even if it only uses the time portion, a date is probably being stored.

What data type did you use for the parameter field SalesTime? Ken Hamady

http://www.kenhamady.com/

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

 

[bKube]

I think there is where the problem is, between access and CR.
Field Access-Date Type Format Saves CR -Val Type

Time Date/Time Medium Time Time Only Time
Date Date/Time Short Date Date Only Date

So for neither Time or Date field are both Date & Time saved.
Thanks for any help, I hope this makes sense.

 

[Guest_imported]

Hi there.

I am writing a report that will be deployed to a user's machine using the Report Distribution Expert. (The user will then click setup.exe to install the report). I want to be able to have a screen come up where the user can enter the date range he/she would like the report to be filtered by. I know you can do this in CR, but I can't remember how. Anyone know? Thanks.

erin