Re: [office-formula] DAY (Section 6.9.4)

[Eike Rathke <erack@sun.com>]

Hi Andreas,

On Friday, 2009-02-13 12:42:33 -0700, Andreas J. Guelzow wrote:

> On Fri, 2009-02-13 at 18:30 +0000, Eric Patterson wrote:
> > I believe that the result of one of the test cases for the DAY() function is incorrect.
> > 
> > The expression, =DAY("2006-12-15") should return 15 not 12 as indicated.
> 
> I think this is a pretty bad test case. DAY takes a DateParam. Now the
> string given here will be translated into a DateParam but the conversion
> is implementation defined (6.2.11)

6.2.11 also says that text should be passed to DATEVALUE(), for which we
define that it "must accept ISO date format (YYYY-MM-DD)", so
DAY("2006-12-15") should be fine.

  Eike

-- 
Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets.  --Robert Weir on the OpenDocument formula subcommittee's list.

PGP signature