View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark J Mark J is offline
external usenet poster
 
Posts: 24
Default dates and pivot tables?

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?