Home Forums SQL Server 2008 SQL Server 2008 - General sql to bypass "dayofweek" and "days" functions RE: sql to bypass "dayofweek" and "days" functions

  • December 20, 2017 at 6:38 pm

    #1973029

    SELECT

    CASE

    WHEN DatePart(dw,(Convert(date, kp_aspirationalschedule)))=7 THEN DateDiff(dd, GetDate(), kp_aspirationalschedule)-1

    WHEN DatePart(dw,(Convert(date, kp_aspirationalschedule)))=1 THEN DateDiff(dd, GetDate(), kp_aspirationalschedule)-2

    ELSE DateDiff(dd, GetDate(),Convert(date, kp_aspirationalschedule))

    END AS [DAYS]