I need setup custom date in my report. Right now report is running based on ORDERDATE using parameters (startdate and enddate).
In my case startdate and enddate are always the same.
What I need is create statement letting me run report based on:
If today is Monday then ORDERDATE = today-3 else if today is any other day of the week (Tue, Wed, Thu, Fri) then
Weekends (Sat, Sun) excluded.
No idea how to do that is SSRS.
thanks for help.