Home Forums SQL Server 2017 SQL Server 2017 - Development Select All Records Where Date Falls Within Next Week RE: Select All Records Where Date Falls Within Next Week

  • April 22, 2018 at 9:34 pm

    #1987835

    Between knowing that day "0" is the first of January, 1900 and that day was a Monday along with a little integer math and a little direct date math, it can be greatly simplified.

    DECLARE @Today DATETIME = '20180417'
    ;
     SELECT *
       FROM dbo.TESTBUILDS
      WHERE [Build Day] >= DATEADD(dd,DATEDIFF(dd,0,@Today)/7*7,7)
        AND [Build Day] <  DATEADD(dd,DATEDIFF(dd,0,@Today)/7*7,14)
    ;

    Just substitute GETDATE() for @Today in the formulas and forget the DECLARE, which was included just to demonstrate.

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