Unable to get any date functions working to update tables from events in LO 7 base. Basic update works but date functions do not

[Rocco]

I am using Linux Mint (Latest Version) On an Intel PC with Libreoffice 7 installed and Access2Base Library
All works well except for DateAdd or DATE_Add functions in Sql Expression which seems strange
I am trying to update a table’s date field from a form’s event Such as

Update “tblMyTable” SET “CalculatedDateField”=DateAdd(‘dd’, “NoOfDaysField”,“AddToThisDate”) where “ClientID”=3

I have followed guidelines regarding quotes, double quotes and apostrophes as needed

I Have had different errors using various combinations of the required expressions
My Table stores NoOfDaysField as an integer,CalculatedDateField as a Date field (‘MM/DD/YYYY’) and AddToThisDate also as a date field with same format.
Even trying to update a date field without using a function fails e.g.

Update “tblMyTable” SET “CalculatedDateField”=‘04/01/2021’ where “ClientID”=3
Any help would be Appreciated.
Libre Office: Version 7.0.4.2
Environment:CPU Threads 8: OS:Linux 5.4
User Interface: UI render: default; VCL:gtk3
Locale:en-US(en-USUTF-8); UI: en-US
Misc: Ubuntu package version:1.777.0.4_rc2-Oubuntu0.20.04.2
Calc: threaded

Could it be that there is a different version for Linux Mint?
I installed Libreoffice 7 using the package manager.
Your Help would be appreciated.
Thank you

[Ratslinger]

Hello,

This appears not to have anything to do with Linux Mint. It is how almost all databases (you do not specify yours) work with a date.

Dates in database are of the format:

YYYY-MM-DD

So if your field & table names are good, this should work:

Update "tblMyTable" SET "CalculatedDateField"='2021-01-04' where "ClientID"=3

Now as far as DateAdd, you seem to be referring to that from Access2Base. Those are basic function to be used in macros and not SQL. Within SQL you need to refer to the user manual for the database you are using (yours not specified). For HSQLDB embedded you will have issues. In that regard see all answers in this post → How to do basic arithmatic with dates in Libre Base queries.