I have created a database and it contains three date fields. Regardless of what date I enter in any of the date fields, the date gets converted to current date. Can’t seem to find an answer to this issue, any help would be greatly appreciated. System is Green G2 with 16GB, running Windows 11 Pro V.24H2 Libreoffice 24.8
which flavor ?
how ?
more likely “ignored”, and using a default value.
(upload your sample .odb, it will clarify what you encounter)
Not sure if this is what you are asking for me to do. But don’t know what else to do. I am new at this.
(Attachment Beaver Creek Indians.odb.lck is missing)
Perhaps you have those fields set to default to CURRENT_DATE
Try editing to fit your Table and executing at Tools>SQL
ALTER TABLE "YourTableName" ALTER COLUMN "YourDateColumnName" DROP DEFAULT;
You would need to run it once for each of your Date fields/columns.
Thanks for your reply, I’ll see if I can do that.