Yesterday data selection - only if business day 1

[ddrake]

Hi all,
I know I've seen this topic in here before, just can't locate the post. I've got a report that chooses a variety of data with a 'Create Date' of yesterday. Of course, this works great Tuesday through Friday! What I need though is something that will select on if yesterday was a business day only so if I run the report on a Monday, it will look at the Friday prior instead of Sunday prior.
I can suck up holidays as inconsequential. Thanks all!!

Dave

 

[kskid]

It was posted earlier today foir a problem addressed by TEM3.

Assuming you run this report Monday through Friday, then modifying the formula.

//@datex
(
if DayOfWeek(CurrentDate) = 2 then
     {table.date} = CurrentDate - 3
   else
     {table.date} = CurrentDate - 1
)

However, be aware that it may take longer processing the report if this is in your record selection. Click on Database->Show SQL Query and see if the date appears. You may have to do what I have done. Make a copy of the report to run on Mondays only with Currentdate - 3

Cheers,
-LW

{table.date} = currentdate - 3

 

[ddrake]

Perfect! On both solutions. Thanks a lot!