Hello- I am trying to run a report that will pull in orders due on Sat, Sun and Mon into a report that will run on Thur.
This report will not be ran adhoc rather I will run it via BOE and have it automatically email to the dept.
I am probably way over thinking this but I just cant get the range (Sat-Mon) to pull in to Thurs report.
I know I would need to use something like this but I need it to include +3 and +4
IF DayOfWeek (currentdate)=5 THEN currentdate+2 ELSE