How do I enter a date range ie -7 from current date in MS QUERY

[Guest]

I am creating an excel pivot table using external data. I want to include
only records that are equal to current date and past 6 days. In otherwords,
on any day that I run the pivot table I would bet current day + 6 days prior
data. How would I setup the criteria and value cell. I can successfully
specify a criteria field and in the value but = date(now()) and this works
fine for current days data but I am having trouble using the > date(now()) -
7. Any suggestions?

Thanks

 

[Roger Govier]

Hi

Personally, I would use Today() rather than Now(), unless you are sensitive
to the hour as well.
I your second criteria cell, are you using the = sign to show it is a
formula i.e. =>Today()-7.
You don't need the Date() function at all
=Today()
=>today()-7


Regards

Roger Govier