Issue 111478 - The usage of the Formular =Days360 (in German: =Tage360) seems to be changed
Summary: The usage of the Formular =Days360 (in German: =Tage360) seems to be changed
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.2.1 RC1
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2010-05-08 13:48 UTC by vohe
Modified: 2013-01-29 21:48 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description vohe 2010-05-08 13:48:42 UTC
Documents with =TAGE360("01.02.2010";Now()) doesn't work any more.

=TAGE360(DATWERT("01.02.2010");Now()) works fine.

But the (german) helpfile tell you, you can use it as sample 1 above shows you.
Comment 1 Oliver Brinzing 2010-05-09 11:34:41 UTC
DAYS() and WEEKDAY are also affected:

DAYS(): same as DAYS360()

WEEKDAY(Number; Type):
Number: the internal number for the date
but helps says, for example: =WEEKDAY("2000-06-14")
btw: in OO 1.1.5 =WEEKDAY("2000-06-14") worked ...
Comment 2 jbf.faure 2010-05-13 14:14:52 UTC

I am not sure there is a bug here. I think you are experienced this change :

In OOo 3.2.1 RC1 FR =JOURSEM("2010-05-13") works fine (JOURSEM = WEEKDAY)
and =JOURS360("2009-05-13";MAINTENANT()) too but
=JOURS360("13/05/2009";MAINTENANT()) give #VALUE! which is correct because
"13/05/2009" is not ISO 8601.

Regards. JBF
Comment 3 vohe 2010-06-25 22:13:54 UTC
May it's correct, that =JOURS360("13/05/2009";MAINTENANT()) or
=TAGE360("01.02.2010";Now()) isn't ISO conform.
But till Openoffice Version 3.1 this works AND the german helpfile show's exact
this as example!
So if there is a new definition of the date-functions, then the help file is
incorrect and existing tables get errors!