Using date field in filter question

[FRED_EMMERICH_(Guest)]

I am using a date field as part of my SQL filter. I noticed in the new version, it also shows the time when you specify the criteria in the filter. Is there a way to get rid of this or will it always be there when you use a date? ____I print the date field on my report, but I have the time turned off.____thanks__Fred

[kfleming]

If you are comparing to a date time field, the comparison will always need to be a date time literal. ____You would need to create a calculated field to convert the date time to just date and then use it as the filter field in order to remove the time part for the comparison.____Kathleen__R&R Support

[FRED_EMMERICH_(Guest)]

I can do that, should have thought of that myself!____thanks__Fred