Posted to microsoft.public.excel.programming

external usenet poster

Posts: 24

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Months / Dates in Pivot Tables	Dave Eade	Excel Discussion (Misc queries)	0	March 23rd 09 01:38 PM
Dates And Pivot Tables	Mike	Excel Worksheet Functions	1	July 30th 08 08:55 PM
Pivot tables and dates	Sue	Excel Worksheet Functions	3	August 24th 07 01:08 AM
Grouping DAtes in Pivot Tables	berby65	Excel Discussion (Misc queries)	4	December 1st 06 11:52 PM
Dates in Pivot Tables	Zani	Excel Programming	1	May 15th 06 03:10 PM

All times are GMT +1. The time now is 07:47 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us