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

["Andreas J. Guelzow" <aguelzow@math.concordia.ab.ca>]

On Wed, 2009-02-25 at 15:02 +0100, Eike Rathke wrote:
> 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.

What does "accept" mean? To me it meant that it cannot return an error.
I see no specification that the return value should then be
DATE(2006;12;15). Might you be making an assumption?

Andreas
-- 
Andreas J. Guelzow, PhD, FTICA
Coordinator, Mathematical & Computing Sciences
Concordia University College of Alberta