Does not include last work day? 1

[willz99ta]

Hi and thanks for your help,

I am trying to not include any dates >= the last work day.

What is the best way to accomplish this?

Thanks again for your help,
Will

 

[lbass]

Well, wouldn't the currentdate always be the last work day?

{table.date} >= currentdate

-LB

 

[willz99ta]

I worded it stangely. I was trying to find the selection formula that would find all dates up to the day before the previous work day.

What I used was:

if
dayofweek(currentdate) = 2 then
{date} < dateadd("d",-3,currentdate)
else if
dayofweek(currentdate) = 1 then
{date} < dateadd("d",-2,currentdate)
else
{date} < dateadd("d",-1,currentdate)


What do you think O Master of What Is Crystal?

Thanks,
Will

 

[lbass]

Looks okay to me.

-LB