I have a date in my pivot table data and I'd like to calculate in a field an
'aging' number of days since today. So, for example, my item has a date of
3/1/09 and today is 3/29/09, I'd like to calculate to 28. This, of course
would change every day the pivot is refreshed.

I've tried using NOW type functions in my pivot table field calculation, but
no luck. Any suggestions?

Thanks,

O
Orrin Wolf