sql formula add business days

SUGGESTED

What would the sql statement be to add 3 business days to the Sales Order Delivery Date?

There is probably a shorter version but I got this to work.

CASE

WHEN DATEPART(day,SO_SalesOrderHeader.ShipExpireDate)=1 then DATEADD(day,3,SO_SalesOrderHeader.ShipExpireDate)

WHEN DATEPART(day,SO_SalesOrderHeader.ShipExpireDate)=2 then DATEADD(day,3,SO_SalesOrderHeader.ShipExpireDate)

WHEN DATEPART(day,SO_SalesOrderHeader.ShipExpireDate)=3 then DATEADD(day,3,SO_SalesOrderHeader.ShipExpireDate)

WHEN DATEPART(day,SO_SalesOrderHeader.ShipExpireDate)=4 then DATEADD(day,5,SO_SalesOrderHeader.ShipExpireDate)

WHEN DATEPART(day,SO_SalesOrderHeader.ShipExpireDate)=5 then DATEADD(day,5,SO_SalesOrderHeader.ShipExpireDate)

WHEN DATEPART(day,SO_SalesOrderHeader.ShipExpireDate)=6 then DATEADD(day,5,SO_SalesOrderHeader.ShipExpireDate)

WHEN DATEPART(day,SO_SalesOrderHeader.ShipExpireDate)=7 then DATEADD(day,4,SO_SalesOrderHeader.ShipExpireDate)

ELSE SO_SalesOrderHeader.ShipExpireDate

END

  • 0
    SUGGESTED

    There is probably a shorter answer but I got this to work.

    CASE

    WHEN DATEPART(day,SO_SalesOrderHeader.ShipExpireDate)=1 then DATEADD(day,3,SO_SalesOrderHeader.ShipExpireDate)

    WHEN DATEPART(day,SO_SalesOrderHeader.ShipExpireDate)=2 then DATEADD(day,3,SO_SalesOrderHeader.ShipExpireDate)

    WHEN DATEPART(day,SO_SalesOrderHeader.ShipExpireDate)=3 then DATEADD(day,3,SO_SalesOrderHeader.ShipExpireDate)

    WHEN DATEPART(day,SO_SalesOrderHeader.ShipExpireDate)=4 then DATEADD(day,5,SO_SalesOrderHeader.ShipExpireDate)

    WHEN DATEPART(day,SO_SalesOrderHeader.ShipExpireDate)=5 then DATEADD(day,5,SO_SalesOrderHeader.ShipExpireDate)

    WHEN DATEPART(day,SO_SalesOrderHeader.ShipExpireDate)=6 then DATEADD(day,5,SO_SalesOrderHeader.ShipExpireDate)

    WHEN DATEPART(day,SO_SalesOrderHeader.ShipExpireDate)=7 then DATEADD(day,4,SO_SalesOrderHeader.ShipExpireDate)

    ELSE SO_SalesOrderHeader.ShipExpireDate

    END