https://bugs.documentfoundation.org/show_bug.cgi?id=95679
Bug ID: 95679
Summary: Case when does not work with the between function in
base versions greater than 3.7
Product: LibreOffice
Version: unspecified
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Keywords: regression
Severity: normal
Priority: medium
Component: Base
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: dti...@hotmail.com
Created attachment 120388
--> https://bugs.documentfoundation.org/attachment.cgi?id=120388&action=edit
small query with 2 tables to show base bug
Case when Does not work with the between function in Libre Base after ver 4.4
4.37 is the last version I found that it still works.
This is the sql used,
WHERE "TransDate,D" BETWEEN CASE WHEN :DateFrom = '' THEN (
"TLOOKUP"."StartDate" ) ELSE TO_DATE( :DateFrom, 'MM/DD/YY' ) END AND CASE WHEN
:DateTo = '' THEN CURRENT_DATE ELSE TO_DATE( :DateTo, 'MM/DD/YY' ) END
It is suppose to default to certain dates if nothing is selected , but the
default dates do not work in the latest versions of Base.
I have included a zip file that has a query and 2 small tables as an example.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
