https://bugs.documentfoundation.org/show_bug.cgi?id=95679
--- Comment #8 from Dave <[email protected]> --- (In reply to robert from comment #6) > (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 Thx very much 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
