No announcement yet.

ISO weeknumber - still up-to-date?

  • Filter
  • Time
  • Show
Clear All
new posts

  • ISO weeknumber - still up-to-date?

    I am using this code:

    I know Egbert is very serious about dates however, a calculation like this:
    INT((yearsBC + yearsAD) * 365.25)

    may be very cpu and programming depending.

    Imo at least vars like: yearsBC AS LONG, yearsAD AS LONG should be double.
    And 365.25 should be tagged as double like:

    Local yearsBC AS Double, yearsAD AS Double

    INT((yearsBC + yearsAD) * 365.25#)

    Not sure if this is ok: FUNCTION = JDN MOD 7 + 1

    FUNCTION = (JDN MOD 7) + 1
    FUNCTION = (JDN MOD (7 + 1))


  • #2
    I don't think that changing yearsBC and yearsAD to DOUBLEs will affect the calculation of that expression if they are always holding LONG values.

    I'm guessing PB is interpreting the numeric literal is as a SINGLE by default and converting the value of the sum to same. Adding the # specifier to force the literal to a DOUBLE should force PB to convert the sum to same and maintain the extra precision it offers through the multiplication.

    Operator precedence with MOD always confuses me too, so I prefer to add explicit parenthesis when using it as you have shown. MOD is calculated before addition (and I doubt that PB has ever changed operator precedence as it would likely break legacy code), so it is calculated:

    FUNCTION = (JDN MOD 7) + 1
    Bernard Ertl
    InterPlan Systems


    • #3
      LONGs can be changed to DWORDs where no negative values are used, and this will double the max upper value of that parameter.

      I have not looked at the code so I do not know if this is the case or not, but would venture to guess that no negative values would be used.
      Scott Slater
      Summit Computer Networks, Inc.


      • #4

        If I were you I wouldn't use that old Julian routine, but the Gregorian Date Library: In its week number function you can force a correct ISO week number.
        Good luck.

        Egbert Zijlema, journalist and programmer (zijlema at basicguru dot eu)
        *** Opinions expressed here are not necessarily untrue ***


        • #5
          Will you ever take care of the values used during calculation?
          I personally had trouble by not explictly force a specific vartype.
          I now always do.

          Part 365.25 for example, i know some programmers lift along with a behaviour of the compiler and in some cases the fraction may result in specific (rounded) values.


          • #6

            I'm not sure what you mean. My function "WeekNumber" does not force a specific vartype. If a negative value (-1) is passed through its optional param, the function returns a weeknumber based upon the following ISO rules:
            • Monday is supposed to be the first day of the week
            • Week #1 is the week that contains the first Thursday of the year

            Also read:

            Egbert Zijlema, journalist and programmer (zijlema at basicguru dot eu)
            *** Opinions expressed here are not necessarily untrue ***