today() pivot table filter

M

monkeypox

New Member
Joined
Aug 1, 2008
Messages
5
I have a pivot table that has a dynamic data connection and want to set a filter so that I can filter and view any dates in the respective date format column that are 14 days earlier and onwards from the current date.

The only way I can think of doing this is with an advance filter, which I have tried on a normal table with the following formula to no success.

= "<="&(today()-14)

Has anyone had this problem in the past and found a solution.

Thanks
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Sort by date Sort by votes
If your data connexion points to a view on an database, you might prepare the view to get the data you want.
Consider also query tables in excel in this case, since these QT allow parameters.
 
Upvote 0
lalbatros said:
If your data connexion points to a view on an database, you might prepare the view to get the data you want.
Consider also query tables in excel in this case, since these QT allow parameters.
Click to expand...

Query Tables, is this using MS query on the pivot table, I just done a search though help and could not find any specific to QT's
 
Upvote 0
You get them by the following menu path:

Data / Import External Data / New database query ...

From this point, you are using then MS Query.
You need "Choose the Data Source" ...

Once you have a sheet filled with the query, you can build a PT on it.
Query tables can be refeshed.
 
Upvote 0
I have got the data in a pivot table, I cannot filter the dates based on the date being dynamic.

I want the table to show all dates that are 14 days or older, I have tried using the >=(today()-14) but does not work.
 
Upvote 0
You must log in or register to reply here.

Similar threads

L
  • Question
Filter date range to last 365 days (Pivot Table)
Replies
2
Views
428
LeonardH
L
B
  • Question
Excel 2021 - Building a Pivot Table on a Filter Function Array
Replies
9
Views
207
BrerRabbit
B
F
  • Solved
Problems filtering a Pivot Table with VBA
Replies
2
Views
192
Domenic
D
B
  • Question
Pivot Table question - could be impossible to implement
Replies
0
Views
526
buroh
B
A
  • Solved
Pivot Table Slicers mystery!!!
Replies
9
Views
841
adambc
A

Forum statistics

Threads
1,214,925
Messages
6,122,301
Members
449,078
Latest member
nonnakkong

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top