I have a Sales report that need to look for Orders entered today. Unfortunately the report doesn't always run before midnight, so I changed the selection formula to check if the time is "AM" and then use CurrentDate -1, which works ok, except for weekends and getting the report to look for Fridays date when the report runs on Sunday night. I would like to have CRD drive the date. Does anybody have any ideas?
The sunday schedule is run weekly on a Sunday only and has Currentdate - 2.
The other schedule stays the same: currentdate - 1. In CRD 5 you will be able to specify the days to run (Monday to Saturday only), but for the moment you would need to use a custom calendar to achieve this.
