Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Now criteria/parameter

Status
Not open for further replies.

michasp

Technical User
Nov 30, 2000
2
US
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.
 

How about DATE() -X where X is number of days to go back. Using DATE()-1 would return yesterdays date.

Jim
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top