DATE_ADD Problem with MYSQL

[RealAg]

I am having this exact same problem with date_add in BASE as was posted here:

Base - MySQL: Trouble with Date_Add Function

I am using LibreOffice Base to make attractive reports based on data I have stored in my MySQL Server. I am having trouble writing a query. More specifically, I have a query that I cannot make work in LibreOffice. The first image is proof that the query runs as expected when input directly into MySQL. As you can see above, there is nothing wrong with the output (other than prehypertension). The same query (with the addition of grave accents (`) where LibreOffice wants them) fails with an SQL…

Is there a fix for this?

[RealAg]

I may have found my own answer to this problem here:

https://bugs.freedesktop.org/show_bug.cgi?id=53867