Now criteria/parameter

[michasp]

Suppose today is Friday and I wanted to make a parameter that sorted from the previous Friday through yesterday (Thur). What would it be?

<Now-

What would follow? Could I use something to the effect of &quot;previous now&quot;, since this will be done automatically every Friday? Can Now take parameters? Thanks.

 

[MichaelRed]

? Format(Dateadd(&quot;d&quot;, -7, Now()), &quot;Short Date&quot
11/24/00


However this may not be sufficient. What happens when/if it is invoked on some other day? Do you just ignore it? Search for the previous friday - regardless of the current day? ... ???



MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over