DateTime 2

[EscapeUK]

I have posted this question a few times but I don't think it was clear what I needed to do.

I have a SQL DB that has a field of type DateTime. I would like a parameter that allows the user to select a date only (not a date and time). If I set the type of the parameter to date I can not use it in the select expert for the date time field.

One thing I have tried is the convert datetime to date in the File Options section. This did not work.

What else can I try??

 

[kenhamady]

You have to do it in File - REPORT Options for it to affect an existing report. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[EscapeUK]

Thats it great thanks