If Then in Select Expert?

[jonmohr]

Can you use an if then in a select expert?

What I'm trying to do is run run a report automatically w/o having to select a date to run it for (no parameters). However, the problem is, I do not want to run the report for Saturdays or Sunday (non-biz days).

So, what I trying to find out is how I can use the following with my date field:

If Currendate = 2 then
{table.date} = Currentdate - 3
else {table.date} = Currentdate - 1

Thanks everyone in advance!

 

[synapsevampire]

Yes, you can use functions in the record selection, and depending upon your software version (please remember to post this) you'd select Report->Edit Selection Formula-Record

If not(dayofweek(Currendate) in [7,1]) then
{table.date} <= currentdate
else
{table.date} <= maximum(lastfullweek)-1

Assumes Sunday as your starting day of the week.

Should be about right...

-k