https://bugs.documentfoundation.org/show_bug.cgi?id=104918
--- Comment #23 from TISSENDIER Pierre <[email protected]> --- Confirmed in : Version: 7.4.2.3 / LibreOffice Community Build ID: 382eef1f22670f7f4118c8c2dd222ec7ad009daf CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded I tried : select "field1","field2", datediff(year,"field3",current_date) from "Table1" is good in Menu/Tools/SQL... SQL direct is wrong in query module return : syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE at /home/buildslave/source/libo-core/dbaccess/source/core/api/SingleSelectQueryComposer.cxx:108 It is incredible that this bug has not been fixed since 2018! -- You are receiving this mail because: You are the assignee for the bug.
