https://bugs.freedesktop.org/show_bug.cgi?id=59978
Alex Thurgood <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |NEW --- Comment #6 from Alex Thurgood <[email protected]> --- 1) Downloaded ODB file submitted by initial reporter. 2) Opened file in LibreOfficeDev : Version 4.1.0.0.alpha0+ (Build ID: 9cae1dc5311c09168fbe1f04bea3d4ee33a04bb) 3) In SQL mode : query works and returns correct result In Query Design mode : query works and returns correct result, date criteria string is automatically represented as > #30/06/1952# in the UI In the Query Wizard, after entering the date as filter criteria, and proceeding to Next until the query synopsis page, the following is displayed : Fields in the Query: NUMLICENCE (COUREUR.NUMLICENCE), NOM (COUREUR.NOM), PRENOM (COUREUR.PRENOM), DATENAISSANCE (COUREUR.DATENAISSANCE) No sorting fields were assigned. Search conditions: DATENAISSANCE is greater than #30/12/1999# No Groups were assigned. No grouping conditions were assigned. Note that under Search Conditions, DATENAISSANCE was set to greater than '1952-06-30' and yet from the synopsis, we can see that the value wasn't parsed correctly or at all, since it has set some completely unrelated other date. CONFIRMING Adding Lionel to CC Alex -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
