Page 1 of 1
Using date field in filter question
Posted: Wed Oct 04, 2006 4:46 pm
by 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
=> Using date field in filter question
Posted: Thu Oct 05, 2006 7:45 am
by 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
==> RE: Using date field in filter
Posted: Thu Oct 05, 2006 9:59 am
by FRED_EMMERICH_(Guest)
I can do that, should have thought of that myself!____thanks__Fred