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

[bugzilla-daemon at bugs.documentfoundation.org]

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

Julien Nabet <serval2412 at yahoo.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |serval2412 at yahoo.fr

--- Comment #5 from Julien Nabet <serval2412 at yahoo.fr> ---
The algo to convert Julian to Gregorian date seems corresponding to
http://mathforum.org/library/drmath/view/51907.html

lpr: since first bVisual FoxPro or just
dBase is for dBase files which has a long story (see
https://en.wikipedia.org/wiki/DBase) so the file format has changed with the
time + those who use and change it to improve it.
Since the first byte of the attached file is 0x30, it seems indeed a file
generated by Visual Fox pro (see https://www.dbf2002.com/dbf-file-format.html).


As you may have seen, depending the source, algo to convert Julian to Gregorian
date is different.

In your link, you indicated:
"There is a free tool called DBF Viewer Plus, which is great, and this is the
tool I used for exporting DBF to xlsx. I know the date displayed by this tool
is correct because it is inline with the data where it originates from. "

Do you have Visual FoxPro to confirm the date? Indeed, perhaps DBF Viewer Plus
may be buggy.

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