https://bugs.documentfoundation.org/show_bug.cgi?id=139315
Bug ID: 139315
Summary: report wizard displays dat field as number in some
cases
Product: LibreOffice
Version: 6.4.7.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Using embedded Firebird 3.0
Define a table EMP with columns
empid autovalue
name varchar
address varchar
startdate date
Now I want startdate to have as default value current_date. The way I prefer to
do this, is to run the SQL command "alter table emp alter column startdate set
default current_date. This works OK.
Now create a query where the condition for startdate is "> current_date - 365".
To make it work, define the query as "run sql directly".
Now create a report on this query using the wizard, just a straight list of all
the fields from the query. The startdate on running the report comes out as a
number. Changing the report properties to refer to the query i.s.o. the sql
statement the report wizard inserted, does not make a difference.
Create from the query a view, and run again the report wizard, this time on the
view, and the startdate comes out as a date, which is the logical thing to be
expected.
Thee report wizard should have done this properly based on the query.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
