[Bug 121492] Base can not filter by dates

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=121492

Graham <g...@hornercs.co.uk> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |g@hornercs.co.uk

--- Comment #1 from Graham <g...@hornercs.co.uk> ---
Issue applies also to 3.4.1 in Win 7 64-bit, HSQL engine.  Entering date in any
format in the Standard Filter dialog does not filter a table, even using the =
operator. All records are returned.  On re-opening the Standard Filter dialog,
all criteria are blank. Entering date in any format in the query wizard does
not create a corresponding condition.  Only entering [operator]#dd/mm/yyyy# in
a query design form has the expected result.

Exception to the above: when using the jdbc driver to MySQL, the Filter
Criterion becomes '{"D yyyy-mm-dd"}' and sticks in the value box, but the table
is still not filtered correctly.  No records are returned, even though there
are matching dates.

Version 3.3 behaved as expected on XP and Win 7 64-bit.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.