LastFullWeek 1

[mtownbound]

How can I shift the lastfullweek from Sunday-Saturday to Wednesday-Tuesday?

 

[lbass]

Use a formula instead, like this:

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

-LB

 

[mtownbound]

Works like a charm!! Thanks!!

 

[IanWaterman]

YOu can use the min and max of LastFullWeek to move dates

Instead of using

datefield = lastfullweek

try

datefield >= min(lastfullweek) + 3 and
datefield <= max(lastfullweek) + 3

Ian

 

[lbass]

Ian,

Except that doesn't take into account that lastfullweek (based on Sunday) would end two days ago (October 6) so maximum lastfullweek +3 would be tomorrow (October 9) not the last full week based on a Weds-Tues approach, which should be October 2 (as of today, October 8).

-LB

 

[IanWaterman]

LB

Posts crossed over as I am a slow typist ;-)

Good point, only thought about post wednesday and forgot about trying to run on a Mon or Tuesday Doh!

Ian