OpenOffice SQL query date selection

I've been searching the web and asked around, but can't seem to find an answer to my problem...

I have a running ODBC connection with my FrontBase database in OpenOffice Base. I manage to select everything I want, but when I only want to show the records between certain dates, or even one date I keep on getting a Semantic Error.

Here's my query:

SELECT * FROM "SALES" WHERE "DATE" = '2014-04-01'

Just in case you suggest using # for the date, it doesn't work either

DATE '2014-04-01' is also unsuccessful :(

Anyone have any ideas?

After a lot of trial and errors I took a closer look at the OpenOfficeBase interface. I was sure nothing was wrong with my statement so there must be something in Base that I'm missing.

In the toolbar there's a button with SQL and a checkmark which says "Execute SQL-command immediatly". Thought it wouldn't do any harm if I enabled it and gave it a try. And there it was, my query with date filter! I have no idea why that button is there or what it's exact function is, but enabling it made my query work.

Thanks anyway for the suggestions, but apparently we've got to look further than just the language ;-)