[Libreoffice-bugs] [Bug 139315] report wizard displays date field as number in some cases

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=139315

--- Comment #7 from Alex Thurgood <iplaw67 at tuta.io> ---
How do you create a view on which to base your report ?

The "create view" option only works from the Tables menu, however, I don't seem
to be able to get it to do the simple subtraction in the way you describe via
the GUI, as I get SQL token errors, or SQL incorrect date formatting errors
when defining the criteria of the view in the GUI and then attempting to move
out of that GUI cell.

Does the view have to be defined via Tools > Options > SQL ?

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201230/852a3303/attachment.htm>