Date criteria in query
 

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.

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.