Home Forums SQL Server 2016 SQL Server 2016 - Development and T-SQL Date Upto 28 days ahead, no weekends RE: Date Upto 28 days ahead, no weekends

  • May 5, 2018 at 12:57 am

    #1989376

    ringovski - Friday, May 4, 2018 4:45 PM

    Thanks for the reply, but how do i apply your cte's to my statement?

    The CTE is only there to provide sample data, it is the WHERE clause that does the trick.
    😎

    WHERE SD.SD_DATE >= CONVERT(DATE,GETDATE(),0)
    AND  SD.SD_DATE <  CONVERT(DATE,GETDATE() + 29,0)
    AND  (DATEDIFF(DAY,0,SD.SD_DATE) % 7) < 5