• Ramesh (12/3/2007)


    Well, you need to interchange * with /

    You are right, (I probably need to sleep more)

    You'll surely need...:D

    Actually, I did indeed mean *.

    multiplying the year (or part of it) by 53 will give a unique range of 53 numbers to every year. Adding the week number withing the year to this number (sine there are no more than 53 weeks a year) will assign a unique number to any year week pair. I really should have explained this 🙂

    Regards,

    Andras


    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software