[dba-issues] [Issue 99586] YEAR function shows wrong results
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=99586 User oj changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from o...@openoffice.org Thu Apr 9 06:43:21 + 2009 --- Closing. - 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 99586] YEAR function shows wrong results
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=99586 User oj changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |INVALID --- Additional comments from o...@openoffice.org Thu Apr 9 06:32:06 + 2009 --- The YEAR function returns a number and no date. When I change the formatting to number all works well. I used the Add Field dialog per D&D and the format was set to number. - 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 99586] YEAR function shows wrong results
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=99586 User fs changed the following: What|Old value |New value Assigned to|dbaneedsconfirm |oj Ever confirmed| |1 Status|UNCONFIRMED |NEW Summary|YEAR function shows wrong |YEAR function shows wrong |results |results Target milestone|--- |OOo 3.x --- Additional comments from f...@openoffice.org Fri Feb 27 09:23:37 + 2009 --- can reproduce in OOO310.m3 as well as CWS rptfix04 - 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 99586] YEAR function shows wrong results
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=99586 --- Additional comments from r4z...@openoffice.org Tue Feb 24 16:06:43 + 2009 --- Created an attachment (id=60450) file with reports - 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 99586] YEAR function shows wrong results
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 r4z...@openoffice.org Tue Feb 24 15:58:03 + 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 format. I can only get good results if I used Properties - Formatting... set to user defined format . - 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org