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.
|