Where is the list of Base SQL functions that work when using Calc as a datasource?

I thought it was here:
https://wiki.documentfoundation.org/Faq/Base/HSQLFunctions#Numerical_Functions

However, I’ve just tested and DATEDIFF doesn’t work—it returns an error that it is unsupported.

It works fine if the embedded database is used, but not when Calc is the data source. However, some functions do still work, like ROUND.

I suppose I can get around it by adding a bunch of extra, hidden columns in the Calc spreadsheet, but that seems really ugly and clunky. A list of what actually works with Calc as the datasource would be great.

Oh, and by the way, extra hidden columns (plus pivot tables) is totally the way to go if anyone else runs into this problem ever. Either that, or skip Calc entirely and do everything from Base.

Here is an old specification list for SQL Functions for file based database drivers relating to Apache OpenOffice - not sure how relevant it is?

Kind of absurd that those functions haven’t been expanded in the last 12 years…that document is dated 2003. However, everything I’ve tried from that list seems to work, and everything I couldn’t get to work (before asking my question here) isn’t on that list. So I think it IS the currently valid list. :slight_smile: Thanks.