Conversion between Datetime and Date data type 1

[HulaGirl]

I am using a ODBC database. "checkpaydate" is a datetime data type field in that database. When I use the field in setting up as one of the parameter for a report, the parameter prompting dialog box showed both date and time selection. How do I hide the time field from users. They do not need to know the time.

I tried to change the the value type in the "Edit Parameter Field" dialog box. It shows only date. But now I can't use the "No lower bound" check box in the "Enter parameter values" dialog box. It gave me a error msg with error log "crw32" and automatically shut down both the report and CR application. How do I do this in a proper way? Please help. Thanks...

 

[dgillz]

Just change your paramter data type to date, and in your record selection formula convert the date/time field to a date:

Date({checkpaydate}) in {?DateRangeParameter} Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com