I am using Microsoft Query to query against an SQL database and place the
data into a pivot table but cannot figure out how to get the preceding 4 days
worth of data. I currently am trying to get this to work using the following;

=#3/13/2007# And <=#3/13/2007 11:59:59 PM#...this works, but i would like this so the report will run without hard coding dates.. i am trying to use this but with no luck.

=getdate() And <=dateadd(dd,-1,getdate())

any ideas?