-
January 7th, 2013, 02:33 PM
#1
Stuck with dating formula
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
Any ideas???
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|