<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - report wizard displays date field as number in some cases" href="https://bugs.documentfoundation.org/show_bug.cgi?id=139315#c7">Comment # 7</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - report wizard displays date field as number in some cases" href="https://bugs.documentfoundation.org/show_bug.cgi?id=139315">bug 139315</a> from <a class="email" href="mailto:iplaw67@tuta.io" title="Alex Thurgood <iplaw67@tuta.io>"> Alex Thurgood</a> <pre>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 ?</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>