Problem description: Standard filter does not work on date fields. When I use a calc sheet, which is connected by base to a writer document and fill in the criteria for searching a date field, the standard filter does not select any record. I know, that the searched date is present in the table. When I switch off the filter and re-open the standard filter, the seach value has been changed to #24-04-04# instead of the desired 24-04-04. So the search action adds two "#" characters to search value, I think that's the reason that the record can't be find. The autofilter functions normal In the calcsheet itself the standardfilter funtions as expected on a date column. Steps to reproduce: 1. .... 2. .... 3. .... Current behavior: Expected behavior: Platform (if different from the browser): Browser: Mozilla/5.0 (Windows NT 6.0) AppleWebKit/537.4 (KHTML, like Gecko) Chrome/22.0.1229.79 Safari/537.4
The title must be changed. You write about a table from Calc, which is the database for the Base-query. I could confirm this behavior for the connection between Base and Calc. When you edit a query and want to get a specific date, you have to change to the direct SQL-mode - and that doesn't work with the standard filter. With the internal HSQLDB the Standard filter works well - with the same query, ODBC-conform Date-value: #24-04-04# which was changed internal to {D'2004-04-24'}.
Have just seen, that I have reported the same bug sometimes before. *** This bug has been marked as a duplicate of bug 52127 ***