Lastfullweek

[scott1971]

Is there any simple way of making the lastfullweek formula look at Monday to Sunday rather than Sunday to Saturday as it currently does? I use this all the time and I'd love to know if there is an easy way around it.

I'm using Crystal-XI.

 

[lbass]

I think you would have to use a record selection formula like:

{table.date} in currentdate-dayofweek(currentdate, crMonday)-6 to
currendate-dayofweek(currentdate,crMonday)

-LB

 

[synapsevampire]

Try:

If dayofweek(currentdate) <> 1 then
{table.date} in minimum(lastfullweek)+1 to
maximum(lastfullweek)+1
else
{table.date} in minimum(lastfullweek)-6 to
maximum(lastfullweek)-6

-k