I have a simple DB in Base with three tables (called 2017, 2018, 2019). All three have a single record for each day of the year and have a date field set as the key. The date format is YYYY-MM-DD. On four occasions over the last year, all of the values of the date field have shifted one day back.
For example, two days ago, my first record in the table 2019 was 2019-01-01. Today, it is 2018-12-31. And all of the following entries are shifted too. It is the same for the other two tables also.
No other data is changed.
The first couple of times it happened, all of the the data was in one large table and I manually corrected each line. The third time, I copied out the data, edited it in Calc, and then imported it back into separate tables, one for each year.
The only thing that has happened to my machine lately is that I traveled to a different time zone (from US Central to US Mountain) and updated my clock to reflect the change.
Although I can't be certain, but I also traveled around the same time as the other issues.
Steps to Reproduce:
1. Create new table, set date field as the key, wait... (maybe change the time zone setting of computer).
Date values shift one day back.
Dates to be correct.
User Profile Reset: No
OpenGL enabled: Yes
Version: 18.104.22.168 (x64)
Build ID: 86daf60bf00efa86ad547e59e09d6bb77c699acb
CPU threads: 4; OS: Windows 10.0; UI render: GL;
Locale: en-US (en_US); Calc: group threaded
To be clear about my time zone change, I traveled to a different time zone (-6:00 -> -7:00), updated my clock. Then came back and corrected my clock again (-7:00 -> -6:00).
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug.
(Please note that the attachment will be public, remove any sensitive information before attaching it.
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
Assuming you are using an embedded hsqldb database, this is a known lack of feature support in the timezone management within LOBase, see for example bug 67763
In particular, read Lionel's remarks in comment 1 of that bug under "Timezone"
*** This bug has been marked as a duplicate of bug 67763 ***
See also the description of current hsqldb behaviour in the opening description of bug 119675, the aim of which is to request, for the complete switch to default of embedded Firebird ODB files, a UI option to set the handling of date/time vaues.