Still getting the same error message
dateadd(day,case datepart(weekday,GetDate()) when 1 then -4 when 5 then -3 when 6 then -3 when 7 then -3 else -5 end,cast(GetDate() as date))
>=dateadd(day,case datepart(weekday,current_timestamp) when 1 then -4 when 5 then -3 when 6 then -3 when 7 then -3 else -5 end,cast(current_timestamp as date)) and OrderDate<cast(current_timestamp as date)
Entered another way and it did this
(DATEADD(day,
CASE datepart(weekday, GetDate()) WHEN 1 THEN - 4 WHEN 5 THEN - 3 WHEN 6 THEN - 3 WHEN 7 THEN - 3 ELSE - 5 END, CAST(GETDATE() AS date)) >= DATEADD(day, CASE datepart(weekday,
CURRENT_TIMESTAMP) WHEN 1 THEN - 4 WHEN 5 THEN - 3 WHEN 6 THEN - 3 WHEN 7 THEN - 3 ELSE - 5 END, CAST(CURRENT_TIMESTAMP AS date))) AND
(dbo.SO_SalesOrderHeader.OrderDate < CAST(CURRENT_TIMESTAMP AS date))
however it is not just showing past 3 business days, it's showing all records
Here's the entire SQL
SELECT PERCENT YEAR(CASE WHEN { fn DAYOFWEEK(dbo.SO_SalesOrderHeader.OrderDate) } IN (1, 7) THEN dbo.DAYSADDNOWK(OrderDate, 1) ELSE DATEADD(dd, 0, DATEDIFF(dd, 0,
dbo.SO_SalesOrderHeader.OrderDate)) END) AS OrderYear, 'Q' + CONVERT(VARCHAR(20), DATEPART(qq, CASE WHEN { fn DAYOFWEEK(dbo.SO_SalesOrderHeader.OrderDate) } IN (1, 7)
THEN dbo.DAYSADDNOWK(OrderDate, 1) ELSE DATEADD(dd, 0, DATEDIFF(dd, 0, dbo.SO_SalesOrderHeader.OrderDate)) END)) AS Quarter,
MONTH((CASE WHEN { fn DAYOFWEEK(dbo.SO_SalesOrderHeader.OrderDate) } IN (1, 7) THEN dbo.DAYSADDNOWK(OrderDate, 1) ELSE DATEADD(dd, 0, DATEDIFF(dd, 0, dbo.SO_SalesOrderHeader.OrderDate))
END)) AS OrderMonth, DATENAME(month, (CASE WHEN { fn DAYOFWEEK(dbo.SO_SalesOrderHeader.OrderDate) } IN (1, 7) THEN dbo.DAYSADDNOWK(OrderDate, 1) ELSE DATEADD(dd, 0, DATEDIFF(dd, 0,
dbo.SO_SalesOrderHeader.OrderDate)) END)) AS MonthName, { fn WEEK((CASE WHEN { fn DAYOFWEEK(dbo.SO_SalesOrderHeader.OrderDate) } IN (1, 7) THEN dbo.DAYSADDNOWK(OrderDate, 1)
ELSE DATEADD(dd, 0, DATEDIFF(dd, 0, dbo.SO_SalesOrderHeader.OrderDate)) END)) } AS Week, { fn DAYOFWEEK((CASE WHEN { fn DAYOFWEEK(dbo.SO_SalesOrderHeader.OrderDate) } IN (1, 7)
THEN dbo.DAYSADDNOWK(OrderDate, 1) ELSE DATEADD(dd, 0, DATEDIFF(dd, 0, dbo.SO_SalesOrderHeader.OrderDate)) END)) } AS DayOfWeek, DATEDIFF(d,
(CASE WHEN { fn DAYOFWEEK(dbo.SO_SalesOrderHeader.OrderDate) } IN (1, 7) THEN dbo.DAYSADDNOWK(OrderDate, 1) ELSE DATEADD(dd, 0, DATEDIFF(dd, 0, dbo.SO_SalesOrderHeader.OrderDate)) END) + 1,
GETDATE()) AS NoOfDays, CASE WHEN { fn DAYOFWEEK(OrderDate) } IN (1, 7) THEN dbo.DAYSADDNOWK(OrderDate, 1) ELSE DATEADD(dd, 0, DATEDIFF(dd, 0, dbo.SO_SalesOrderHeader.OrderDate))
END AS OrderDate, DATEADD(dd, 0, DATEDIFF(dd, 0, dbo.SO_SalesOrderHeader.OrderDate)) AS ActualOrderDate, dbo.SO_SalesOrderDetail.ItemCode,
CASE WHEN UDF_CATEGORY_SPECIFIC = '' THEN 'Not Labeled' ELSE UDF_CATEGORY_SPECIFIC END AS SpecificCategory,
CASE WHEN UDF_CATEGORY_GENERAL = '' THEN 'Not Labeled' ELSE UDF_CATEGORY_GENERAL END AS Category, CASE WHEN UDF_MACHINE = '' THEN 'Not Labeled' ELSE UDF_MACHINE END AS Machine,
dbo.SO_SalesOrderDetail.QuantityOrdered - dbo.SO_SalesOrderDetail.QuantityShipped AS QOO, dbo.SO_SalesOrderDetail.ExtensionAmt AS Amt, dbo.SO_SalesOrderHeader.OrderStatus
FROM dbo.SO_SalesOrderDetail INNER JOIN
dbo.SO_SalesOrderHeader ON dbo.SO_SalesOrderDetail.SalesOrderNo = dbo.SO_SalesOrderHeader.SalesOrderNo INNER JOIN
dbo.CI_Item ON dbo.SO_SalesOrderDetail.ItemCode = dbo.CI_Item.ItemCode
WHERE (CASE WHEN UDF_CATEGORY_SPECIFIC = '' THEN 'Not Labeled' ELSE UDF_CATEGORY_SPECIFIC END <> 'WHOLESALE') AND
(CASE WHEN UDF_CATEGORY_SPECIFIC = '' THEN 'Not Labeled' ELSE UDF_CATEGORY_SPECIFIC END <> '') AND
(CASE WHEN UDF_CATEGORY_SPECIFIC = '' THEN 'Not Labeled' ELSE UDF_CATEGORY_SPECIFIC END <> 'Not Labeled') AND (NOT (dbo.SO_SalesOrderHeader.OrderStatus IN ('C', 'Z', 'X'))) AND (DATEADD(day,
CASE datepart(weekday, GetDate()) WHEN 1 THEN - 4 WHEN 5 THEN - 3 WHEN 6 THEN - 3 WHEN 7 THEN - 3 ELSE - 5 END, CAST(GETDATE() AS date)) >= DATEADD(day, CASE datepart(weekday,
CURRENT_TIMESTAMP) WHEN 1 THEN - 4 WHEN 5 THEN - 3 WHEN 6 THEN - 3 WHEN 7 THEN - 3 ELSE - 5 END, CAST(CURRENT_TIMESTAMP AS date))) AND
(dbo.SO_SalesOrderHeader.OrderDate < CAST(CURRENT_TIMESTAMP AS date))