To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=99586 Issue #|99586 Summary|YEAR function shows wrong results Component|Database access Version|OOO310m1 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|SRB Assigned to|dbaneedsconfirm Reported by|r4zoli
------- Additional comments from [email protected] Tue Feb 24 15:58:03 +0000 2009 ------- OOO310m2 with SRB from Pavel build. I created all reports with wizard, based on query, and later modified them. (Added charts to reports, they are independent from this issue) I started to check new function wizards from Conditional Print Expression and from Data field, result with YEAR functions, gave mixed result. >From Data field: all dates changed to 1905-..-.. (original dates between 1899-2009). I get similar results, if I modified report to SQL command source. >From Conditional Print Expression: shows full date instead of YYYY format. I can only get good results if I used Properties - Formatting... set to user defined format YYYY. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
