<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Date field values change in Base"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=122863">122863</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Date field values change in Base
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.1.3.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Base
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>ken@thegramms.net
</td>
</tr></table>
<p>
<div>
<pre>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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>