[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 #4 from Julien Nabet <serval2412 at yahoo.fr> ---
Ok it worked.

Now I'm trying to make the query and with SQL edit, this works:
SELECT * FROM "EMP" WHERE "startdate" > CURRENT_DATE
not this:
SELECT * FROM "EMP" WHERE "startdate" > CURRENT_DATE - 365
or even this:
SELECT * FROM "EMP" WHERE "startdate" > (CURRENT_DATE - 365)
I got syntax error without precision.

-- 
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/6a2f189d/attachment.htm>