MS-SQL Stored procedure predefined for day's of the week.

I want to create a stored procedure on a MS-SQL database so that when it's called it is pre-defined to select data based on whatever day of the week it is. My issue is with when the report is run on a Monday I need to see data that may have been update during the last 3 days (Friday, Saturday and/or Sunday) all other days I only need the previous day.  I have the rest of the stored procedure worked out I'm just having trouble wrapping my head around this one exception. Here is the select code without the date parameters.  The date field I'm looking at is: "OrdDate" alias of the "dbo.OrderHeader.DateTimeLastModified" (native format DateTime)

SELECT CAST(dbo.OrderHeader.DateTimeLastModified As Date)AS OrdDate, dbo.OrderHeader.OrderNumber, dbo.OrderLine.LineNumber, dbo.AVOOption.Name AS [Installer Name], dbo.OrderLineAVO.CostPrice, dbo.OrderLineAVO.SellPrice, dbo.OrderLineAVO.TotalCostPrice, dbo.OrderLineAVO.TotalSellPrice, dbo.OrderHeader.OrderType, dbo.AVOOption.AVOID
FROM ((dbo.OrderHeader WITH(NOLOCK) INNER JOIN dbo.OrderLine WITH(NOLOCK) ON dbo.OrderHeader.OrderID = dbo.OrderLine.OrderID) INNER JOIN dbo.OrderLineAVO WITH(NOLOCK) ON dbo.OrderLine.OrderLineID = dbo.OrderLineAVO.OrderLineID) INNER JOIN dbo.AVOOption WITH(NOLOCK) ON dbo.OrderLineAVO.AVOOptionID = dbo.AVOOption.AVOOptionID
WHERE (((dbo.OrderHeader.OrderType)=5) AND ((dbo.AVOOption.AVOID)=5) AND ((dbo.OrderHeader.Deleted)=0) AND ((dbo.AVOOption.Deleted)=0)) OR (((dbo.OrderHeader.OrderType)=6) AND ((dbo.AVOOption.AVOID)=6));

Select allOpen in new window