One of the tables in my database has about 350 records. There is a date affixed to each record. When I loaded the database today, I discovered that the date for all the records is off by a day, each having been changed to one day earlier, e.g., a date that was entered as 23-11-26 is now 23-11-25.
I have no idea what has caused this, though given the systematic way in which the dates have been changed, I would suspect something about how Libreoffice interacts with the underlying OS with respect to time and date. I am currently running Libreoffice 7.4.7.2 on Debian Bookworm. The change to Bookworm, however, is relatively recent. I was running Ubuntu until a few weeks ago. I then installed Debian testing, was having a few issues unrelated to Libreoffice, which resulted in my reinstalling the OS a few times with Debian testing at first, and then with Bookworm. Probably the version of Libreoffice Base that comes with the testing branch is a newer version than what gets installed by default in Bookworm. Not sure if that had anything to do with it.
At any rate, I would like to correct these dates. Is there a quick and dirty way to do it that doesn’t involve fixing these 350 records manually one by one?