To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=91521
------- Additional comments from [EMAIL PROTECTED] Tue Jul 15 18:50:05 +0000 2008 ------- See online help for syntax and definition of the MONTH-function: <quote> MONTH(Number) Number, as a time value, is a decimal for which the month is to be returned. </quote> The MONTH-function is not meant to process text. You can not complain about a function´s result when using invalid arguments. You may complain about the inconsistent behaviour of "foreign builds", though. The only correct way to process the number of the month out of the text value 'Apr 1 is: =MONTH(DATEVALUE(A1)) Try this and you will get an error code in case the text can not be interpreted as a date. That´s just what you expect. ;-) --------------------------------------------------------------------- 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]
