[Libreoffice-bugs] [Bug 122863] New: Date field values change in Base

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=122863

            Bug ID: 122863
           Summary: Date field values change in Base
           Product: LibreOffice
           Version: 6.1.3.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: ken at thegramms.net

Description:
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).

Actual Results:
Date values shift one day back.

Expected Results:
Dates to be correct.


Reproducible: Sometimes


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Version: 6.1.3.2 (x64)
Build ID: 86daf60bf00efa86ad547e59e09d6bb77c699acb
CPU threads: 4; OS: Windows 10.0; UI render: GL; 
Locale: en-US (en_US); Calc: group threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190121/616d82e6/attachment.html>