vba_monkey
Board Regular
- Joined
- Dec 18, 2013
- Messages
- 112
Hello,
I'm trying to use VBA to filter an OLAP Pivot Table for all dates that fall three months before the current date. the dates are in the dd/mm/yyyy format and there are hundreds of unique values so I've no idea how to do this.
This is is an example from the macro recorder:
Any ideas please?
I'm trying to use VBA to filter an OLAP Pivot Table for all dates that fall three months before the current date. the dates are in the dd/mm/yyyy format and there are hundreds of unique values so I've no idea how to do this.
This is is an example from the macro recorder:
Code:
.PivotTables("PivotTable5").PivotFields("[DIM POLICY INFO].[POLICY EXPIRY DATE].[POLICY EXPIRY DATE]").VisibleItemsList = Array("[DIM POLICY INFO].[POLICY EXPIRY DATE].&[2017-12-30T00:00:00]")Any ideas please?
