Selecting Pivot Items between set dates

Hi,

I have a pivot table with data imported from another spreadsheet source on a weekly basis. The pivot displays Sales Rep name, created (a date & time value) down the left hand side and revenue summed in the table area.
Each monday i want to update the pivot table with new data and only display the rows with dates for the previous week. e.g. for this week show dates between 14/06/2010 and 20/06/2010. The report will normally be created on the monday of the following week so maybe something using today () -7 extra.

I had a go and go pretty close using cell values as the days I wanted to display but have lost the code.

Any Ideas?

Thanks

I have been able to change the dates to just date with no time. is there a way of getting all pivot items between two dates?

i tried the code below and it worked when i manually entered a date where i have written "date()" but using date() does not work. Have I got the code slightley wrong? Or can I use a input box to get the user to enter a date range, or perhaps just look up a value in the spreadsheet?

Please Login or Register  to view this content.

Thanks that works but i get a run time error '13' type missmatch then the second half does not work and has the same error, even if i comment out the first half

Please Login or Register  to view this content.

thanks thats great