[Libreoffice-bugs] [Bug 125878] New: Dates imported incorrectly from dbf file

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 125878
           Summary: Dates imported incorrectly from dbf file
           Product: LibreOffice
           Version: 6.2.3.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: alper.yenilmez at gmail.com

Description:
When I open a dbf file (foxpro), date appears to be incorrect.

For example:
01/06/2019 17:05:03 becomes 02/06/2019 10:05:02 and
02/06/2019 21:27:33 becomes 03/06/2019 18:27:32

You can try replicating the issue using this file (please change the extension
from xls to dbf, this is the only way I could upload this samle file, as dbf
format is not allowed)

https://ask.libreoffice.org/upfiles/15602705975313146.xls 

And this file is for comparison reasons only, which has the correct date. This
file is exported using "DBF Viewer Plus" - and I can confirm that date/time is
accurate.

Steps to Reproduce:
1. Open a dbf file (foxpro)
2. Check the date/time
3. You will notice that they are incorrect

Actual Results:
02/06/2019 10:05:02

Expected Results:
01/06/2019 17:05:03


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Please note that dbf file is a FoxPro file. Sample files can be found on the
forum:
https://ask.libreoffice.org/en/question/197142/incorrect-date-when-opening-a-dbf-foxpro-file/

I have tried this on Win10 as well as MacOS Mojave - results are identical.

NOTE: I will try to attach original dbf file to this report, but I'm not sure
if it will be allowed. I will try once the bug is filed.

-- 
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/20190612/f9da9936/attachment.html>