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
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