https://bugs.documentfoundation.org/show_bug.cgi?id=95679
--- Comment #6 from [email protected] --- (In reply to Dave from comment #4) > > This query has worked fine in all libre base versions up to and including > ver 3.7 In ver 4.0 it did not work at all Ver 4.4 and above it runs but > you have to enter dates the defaults no longer work. Wrote this in comment 3: A date could not be an empty string. This was wrong in all versions up to LO 4.4. Forms worked in an other (right) way than the query. This bug has been solved. Please change your code: WHERE "TransDate,D" BETWEEN CASE WHEN :DateFrom IS NULL THEN ( "TLOOKUP"."StartDate" ) ELSE TO_DATE( :DateFrom, 'MM/DD/YY' ) END AND CASE WHEN :DateTo IS NULL THEN CURRENT_DATE ELSE TO_DATE( :DateTo, 'MM/DD/YY' ) END Regards Robert -- 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
