dates and pivot tables?

[Mark J]

i am using microsoft query to get data from sql table and am trying to get
the last 4 days but not today's data, but this does not seem to work, it will
pull all days,ie...

3/13, 3/12, 3/11, 3/10, 3/9 ,

=getdate()-5 And <getdate(),

i only want;
3/12, 3/11, 3/10, 3/9

any ideas?