GETPIVOTDATA - Date

W

WC

Hi

When using the GETPIVOTDATA function in Excel2000, I can't
get it to work on a date field.
In the example below, when I try getting a total for "A",
for the date "2003-05-30", I get an #REF error. Does
anyone know how to code the GETPIVOTDATA statement so this
will work?

Thanks.

Sample:

Face_Amt Type As_of_Date Total
AcctClass 2003-05-30 00:00:00 2003-06-27 00:00:00
A 67,175 67,852 135,027
 
Top