ISOWEEKNUM definition and second parameter

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Minor
    • ODF 1.2 CD 06
    • Affects Version/s: ODF 1.2 CD 05
    • Component/s: OpenFormula
    • None
    • Hide

      Replace Syntax
      "
      ISOWEEKNUM( DateParam Date [ ; Integer Mode = 2 ] )
      "
      with
      "
      ISOWEEKNUM( DateParam Date )
      "

      Replace the entire Semantics text, including the mode table, with
      "
      Returns the ordinal number of the ISO 8601 calendar week in the year for the given date. ISO 8601 defines the calendar week as a time interval of seven calendar days starting with a Monday, and the first calendar week of a year as the one that includes the first Thursday of that year.
      "

      Remove the first two test cases.

      Show
      Replace Syntax " ISOWEEKNUM( DateParam Date [ ; Integer Mode = 2 ] ) " with " ISOWEEKNUM( DateParam Date ) " Replace the entire Semantics text, including the mode table, with " Returns the ordinal number of the ISO 8601 calendar week in the year for the given date. ISO 8601 defines the calendar week as a time interval of seven calendar days starting with a Monday, and the first calendar week of a year as the one that includes the first Thursday of that year. " Remove the first two test cases.

      ISOWEEKNUM reads (under semantics):

      "Returns the number of the ISO 8601 week in the year for the given date. Note that this is not the "conventional" week number used by some applications (for that, see WEEKNUM). In this system, week number 1 of any year is the week that contains January 4, because (1) Monday is considered the first day of the week, and (2) a week that lies partly in one year and partly in another is assigned a number in the year in which most of its days lie."

      First, what is the reference "In this system..." ISO I assume?

      Second, "conventional" week is defined only by not being the ISO 8601 week. That seems weak to me.

      Under both definitions, there are options to start weeks on Monday or Sunday. Was that intentional? I say that because of the table under ISOWEEKNUM and the prose under WEEKNUM. How does that interact with considering Monday to be the first day of the week?

      I am looking at ways to calculate the ISO week number, not sure if that will be helpful or not.

            Assignee:
            Eike Rathke (Inactive)
            Reporter:
            Patrick Durusau
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: