Home Forums Article Discussions Article Discussions by Author Discuss content posted by Sean Senneka Get date for iteration of a DOW RE: Get date for iteration of a DOW

  • February 20, 2018 at 2:58 pm

    #1980558

    It's broke...

    DECLARE
       @Year

    SMALLINT= 2017
    , @MonthTINYINT= 10 -- 1-12
    , @DOW TINYINT= 1 -- Sunday = 0, Monday = 1, ect...
    , @ItrTINYINT= 1 -- iteration of specified DOW
    BEGIN
    DECLARE@1stDATE = CONVERT(VARCHAR(2),@Month)+'/1/' + CONVERT(VARCHAR(4),@Year);
    DECLARE@RtrnDtDATE = DATEADD(DAY,((CEILING((CONVERT(DECIMAL(8, 2),17) % DATEPART(dw, @1st)) / 10) * 7) + (@DOW+((@Itr-2)*7))+1) - DATEPART(dw, @1st), @1st);
    SELECT @RtrnDt
    END

    --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)