Wrong operand order in 6.10.6 DAYS in ODF 1.3 part 4

XMLWordPrintable

    • Type: Bug
    • Resolution: Applied
    • Priority: Major
    • ODF 1.4
    • Affects Version/s: None
    • Component/s: None
    • Hide

      Replace

      If they are both Text, this is DATEVALUE(StartDate) – DATEVALUE(EndDate)

      with

      If they are both Text, this is DATEVALUE(EndDate) – DATEVALUE(StartDate)

      Show
      Replace If they are both Text, this is DATEVALUE( StartDate ) – DATEVALUE( EndDate ) with If they are both Text, this is DATEVALUE( EndDate ) – DATEVALUE( StartDate )
    • Hide

      As proposed.

      Show
      As proposed.

      The current text is

      Semantics: Returns the number of days between two dates. If StartDate and EndDate are Numbers, this is EndDate – StartDate. If they are both Text, this is DATEVALUE(StartDate) – DATEVALUE(EndDate).

      Notice that for Numbers it is EndDate-StartDate, but for Text the other way round.

            Assignee:
            Unassigned
            Reporter:
            Regina Henschel
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: