GETPIVOTDATA and Date-type field (Excel 2007)
 

Data Sample
***************
Trip 0346210980
Statement Date 3/24/2010
Description STARBUCKS
Date 03/08/2010
LocCurrAmt 3.47



Formula: =GETPIVOTDATA("LocCurrAmt",A6,"Statement Date",DATE(2010,3,24))

Problem: I keep getting a #REF error. When I evaluate the error it's
always with the DATE function.

Steps I've taken:
1. Confirmed that my date is a number and not text.
2. Tried using the date serial number (40261) instead of the DATE function.
3. Confirmed the GETPIVOTDATA works with just the ("LocCurrAmt",A6)

I'm trying to get the sum of the March 24 statement displayed outside the
pivot table. What may I be doing wrong?