• balars_2000 (6/9/2009)


    hi mate

    thanks for ur response; appreciate it.

    sorry if i wasnt clear, i need week numbers and week start dates for any given date range or a year. if it was a year, for example 2009, the output would be

    week # week start date

    1 05/01

    2 12/01

    3 19/01

    and so on till current date. if it was for a date range for example between 19/01 and 2/02 (for 2009) then it should be

    week # week start date

    1 19/01

    2 26/01

    3 02/02

    thanks again for ur time 🙂

    What do you want if data is missing for a whole week during the year?

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)