Libreoffice base connected in postgresql - how to return a date calculating (current_date - 30 days )

In postgresql i used:
current_date - interval ‘30’ day

when i run this query in base, i have a syntax error.

What can i do?

Hello,

The Base query window does some basic checking based upon using HSQLDB database (default). To bypass this you need to turn on Run SQL command directly:

image description

This is an icon on the toolbar and is a toggle. It is also available from the menu under Edit.

exactly!
Saved by a button!
Thanks for the quick response.