getpivotdata for dates

[munna123]

Pivot table

Exec_Date Pass Fail Blocked
06/02/2011 5 8 10
06/03/2011 8 23 4

From above pivot table I want to retrieve data based on condition
I am writing below code but getting error

Getpivotdata("Exec_Date",$A$4,"Exec_Date", "06/02/2011","Status","Pass")

Please let me know how to write code for this. Thanks

[Domski]

Try:

Getpivotdata("Exec_Date",$A$4,"Exec_Date", Date(2011,6,2),"Status","Pass")

Dom

[munna123]

Thanks Domski .I tried this but still getting error .I tried Vlookup for this also getting answer but refreshing pivot table every day pass,fail,blocked column is not static ,adding new column in pivot table .Please let me know about this .Thanks

[Domski]

The easiest way to get the syntax for GETPIVOTDATA is to pop = in a spare cell and select a summary cell within your pivot table.

Dom