https://bugs.freedesktop.org/show_bug.cgi?id=43967
Bug #: 43967
Summary: VIEWING: Report builder wizard improperly formats
dates
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.4.4 release
Platform: Other
OS/Version: All
Status: UNCONFIRMED
Status Whiteboard: BSA
Severity: normal
Priority: medium
Component: Database
AssignedTo: libreoffice-bugs@lists.freedesktop.org
ReportedBy: rpeter...@gmail.com
Created attachment 54585
--> https://bugs.freedesktop.org/attachment.cgi?id=54585
Screenshot of report output showing poorly formatted dates
I build a query to my database which includes dates and other information in
each row.
I use the report wizard to build a report from that query and the dates are
formatted wrong.
Query Date Report Date
07/01/94 34516
09/01/97 35674
11/01/98 36100
12/01/08 39783
12/01/09 40148
Note that the difference between "Report Date" values for 12/01/08 and 12/01/09
(40148 - 39783) is EXACTLY 365 (days) and the difference between "Report Date"
values for 11/01/98 and 12/01/09 (40148 - 36100) is 4048 (days). Both
differences are EXACTLY the correct number of days. So it seems obvious that
the formatting is wonky -- its showing the number of days since about 1900,
instead of a "date"
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
