M
Michael Weiss
Did you ever get a solution to this? This is exactly the
same issue I am running into now and have not been able
to figure out the correct syntax to make it work...if I
pass in via the Array() function in vbscript:
Dim strDateFilter
strDateFilter = ""01/11/2003","01/12/2003","01/13/2003""
pview.FilterAxis.FieldSets("Call
Date2").AllIncludeExclude = ptable.constants.plAllInclude
pview.filteraxis.fieldsets("Call Date2").fields("Call
Date").includedmembers = _
Array(strDateFilter)
Nothing happens. However if I use:
pview.filteraxis.fieldsets("Call Date2").fields("Call
Date").includedmembers = _
Array("11/01/2003","11/02/2003")
The pivot control filters properly...
Anyone have any ideas?
Thank you,
Michael
same issue I am running into now and have not been able
to figure out the correct syntax to make it work...if I
pass in via the Array() function in vbscript:
Dim strDateFilter
strDateFilter = ""01/11/2003","01/12/2003","01/13/2003""
pview.FilterAxis.FieldSets("Call
Date2").AllIncludeExclude = ptable.constants.plAllInclude
pview.filteraxis.fieldsets("Call Date2").fields("Call
Date").includedmembers = _
Array(strDateFilter)
Nothing happens. However if I use:
pview.filteraxis.fieldsets("Call Date2").fields("Call
Date").includedmembers = _
Array("11/01/2003","11/02/2003")
The pivot control filters properly...
Anyone have any ideas?
Thank you,
Michael