Hi Alex, > As usual, the 2 day date bug has come back to haunt us once again. See, > for example Issue 61949. > > This bug also manifests itself in any date calculation that relies on > data from a db date field when such data is included in a Calc or (as in > my user's case scenario) Writer. > > I have now had reports of the YEAR and MONTH functions, when used in > Writer merge fields on date values obtained from a DB, incorrectly > displaying the whole date instead of the value for the year or the month > respectively, while testing OOo 2.0.3 rc3 FR. Has the number format > module been hosed again ?
This doesn't really have to do with number formatting. The problem is that in the underlying core in all applications, dates are not transferred as "day, month, year", but as "days since <whenever>", where <whenever> is application-, context-, and settings-dependent. And all those places taking a date from whereever, processing it, and using it in a new context, are prone to "forget" that there might be different bases for date calculation. While this is a wonderful (ehm) technical explanation, it doesn't help the user anything. But it might explain that there is no single point where this problem can be fixed, since in real it's a plurality of problems ... Sorry to say that. I agree that every occurance is a potentially severe issue, since it trashs the user's data. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
