View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim May Jim May is offline
external usenet poster
 
Posts: 477
Default Date criteria in query

Are you working with the Advanced FIlter Tool?
If so, then set your criteria as follows:

example in Cells Z1:Z2

Z1= CriteriaHeader
Z2= = " & today() - 7"

Give that a go..
HTH


" wrote:

What would the syntax be in the "Value" line of a field if I wanted
only the most recent seven days to appear in the results?

Thank you.