To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69463 Issue #|69463 Summary|Dateserial function accepts day values past end of mon |th for short months Component|framework Version|OOo 2.0.3 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|scripting Assigned to|npower Reported by|mhatherly
------- Additional comments from [EMAIL PROTECTED] Mon Sep 11 10:01:10 -0700 2006 ------- The dateserial function will accept dates containing a Day value of 31 for months containing only 30 days. For example, Dateserial(2005,06,31) will return the serial date for July 1. The function should return an error code of 5, just like when the entry is dateserial(2006,06,32). February has a similar problem with day = 30 and day = 29 for non-leap years. If the decision is made not to fix this, the documentation in the OO Basic help should note this so users don't try to use dateserial with error trapping to validate dates. --------------------------------------------------------------------- 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]