[RESOLVED] parameter (Date)

[girl81]

hi everybody..

i'm used an access and Crystal Report 8.5.
datatype for Date in Access=Date/Time

In Crystal Report, i've set parameter for date.Of course the format is Date and Time.

{dte_claiming.date} in {?Date} to {?Date To}

How if i just want to show date only (Dont want to show time) during runtime.
So that i can just choose date only.No need to Change Time.

any helping is very much appreciated.
tq

[brucevde]

I am not exactly sure what you are asking but

if you just want to prompt the user for a date value set the Value Type of the parameter to Date instead of Date and Time.

if you are asking how to display just the date on the report, right click on the field on the report and then select Format.

[girl81]

Thanks for reply.

yes i just want to prompt the user for date only.i set it to the Value Type of the parameter to Date and Time because i set DataType for Date to Date/Time in Access .So if i choose value type for parameter to Date only...It cannot detect date that i retrieve from Access because the datatype is different.

so hope anyone can give me a suggestion.
tq

[brucevde]

It cannot detect date that i retrieve from Access because the datatype is different.

Are you getting an error? It works perfectly fine for me.

Which data access method are you using to connect to the Access database?

[girl81]

Thanks brucevde.

I changed date/time to date and its working properly.

Tq