hello all
I am trying to create a range date for my query and I am gettin the
following error:
"Parameters are not allowed for this query"
It looks like the parameters are not allowed when I am doing a query
for a PivoTable, because when I used the same parameters when building
just a Build-Query it will work just fine. This is what I have in the
criteria:
Criteria Field: Period Ending
Value: = [StartDate], [EndDate]

can somebody help me here, why why why this can not work when creating
a PivotTable?...its so frustrating
If this is not possible, Is there any way around to get a date range?

Thanks in advance

Got it working