https://bz.apache.org/ooo/show_bug.cgi?id=121492
--- Comment #33 from Andreas Säger <[email protected]> --- Thank you very much for fixing this nasty one. My tests with AOO420m1(Build:9800) - Rev. 1702819 2015-09-14_03:50:18 - Rev. 1702851 and Linux(64) Filtering dates works well with a registerd data source in the data source window and in the mail merge dialog. 1.7.99 snaps in as #01.07.1999# with German locale 7/1/99 snaps in as #07/01/1999# with US locale It works equally well with grid views opened from the database window, with form based filters and dialog based filters ("standard filter") and when entering date arguments to the query designer. Hard coded ISO date strings work well as in: SELECT * FROM "TBL" WHERE "D" BETWEEN '1999-12-01' AND '2000-03-01' BUT NOT any hashed dates: SELECT * FROM "TBL" WHERE "D" BETWEEN #1999-12-01# AND #2000-03-01# (I think this is perfectly fine since localized (hashed) dates should follow the locale of the current GUI and should not be hard coded in SQL) I can substitute date parameters of parameter queries with localized dates and ISO dates as in SELECT * FROM "TBL" WHERE "D" BETWEEN :Date1 AND :Date2 Parameter substitution works with subforms and with the built-in dialog. Function call with parameter: SELECT "TBL".* FROM "TBL" WHERE Month("D") = Month(:Param) I can create reports from the above queries. Right now, I don't know what else could be tested. -- You are receiving this mail because: You are the assignee for the issue. You are on the CC list for the issue.
