LastFullWeek Formula?

[Tbrandes]

What would the formula look like for last full week with Monday being the first day of the week instead of the default sunday=1 LastfullWeek in Crystal 8.5. I am wanting to setup a report that runs the lastfullweek using Monday thru Sunday. The default for LastFullWeek in Crystal is Sun thru Sat.

 

[synapsevampire]

Try:

if dayofweek(currentdate) = 1
{table.date} in minimum(lastfullweek)-6 to maximum(lastfullweek)-6
else
{table.date} in minimum(lastfullweek)+1 to maximum(lastfullweek)+1

-k