last full week -- Saturday through Friday? 1

[willz99ta]

Hi,

I am trying to have my selection query pull the last full week Saturday through Friday. Is there a way to do that?

Thanks,
Will

 

[lbass]

You could use:

{table.date} in minimum(lastfullweek)-1 to maximum(lastfullweek)-1

-LB

 

[willz99ta]

Nice. Thanks again LBass --- It's like having your own LBass Crystal Genie on this forum!

 

[lbass]

Actually this isn't the correct way to do this, since it won't work correctly on certain days. The Help section says so change the print date to do this, but you might be able to use the following:

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

...where the "7" designates the starting day of the week. You should test this to see if works as expected.

-LB

 

[willz99ta]

Thanks for the followup