https://bugs.documentfoundation.org/show_bug.cgi?id=95679
--- Comment #4 from Dave <dti...@hotmail.com> --- Hi Thx for all the responses! The reports have nothing to do with the problem sorry I left them in. If you run the query it should ask you for 2 dates a begining and and ending date. The DateFrom and Date To in the parameter input Box. Date Format is MM/DD/YR If you do not enter any dates, the SQL, defaults to pre selected defaults. In this case it uses the field StartDate field from the Tlookup Table as the beginning or (DateFrom) date. The end date then defaults to the Current_Date if no DateTo ( ending date) is entered. 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. This is HSQLDB version 2.3 database running is split mode on a windows 10 computer Thank you for all your considerations Dave -- 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