LastFullWeek Starting with Different Week Day 1

[mychal]

I'd like a date range in my CR 8.5 selection criteria that is like LastFullWeek, but instead of Sunday to Saturday, I want Monday to Sunday.

Instead of

{date field} in LastFullWeek,

I would use

{date field} in [{start date} to {end date}].

So for example, if I run the report on Wednesday, August 11th, 2004, the report would display data between 8/2 and 8/8.

How can I do this?

Gracias.

 

[bdreed35]

You can try this:

{date field} in (LastFullWeek + 1) to (LastFullWeek + 1)

~Brian

 

[bdreed35]

My bad, psted to quick.

It should be this:

{date field} in (Minimum(LastFullWeek) + 1) to (Maximum(LastFullWeek) + 1)

~Brian