pivot table with calcuated field for date

Hi, I'm trying to put in a calculated field into a pivot table, containing an if statement for dates and calculating a monetary amount. What I've tried so far in the calcualted field formula entry is (in simplified form):

=IF('date of transaction'<DATE(2011,1,1),'Fees'*0.005,'Fees'*0.0045)

The first "date of transaction" is the pivot field. The second "DATE" is just formattting for the formula. The "Fees" is another pivot field.

The formula itself is working, because I am not getting errors of anything like that. But, everything is coming back calculated under the false scenario (.0045).

When I do this "if" formula outside of the pivot table, using "getpivotdata" to get the "date of transaction" field, it works fine. What am I missing here?

Thank you for any help!


EDIT:

I should have also mentioned, that within the true and false operations, I'm using a couple extra functions, like round and min. I can't imagine that would be the cause of the problem though...since the equation is solving succesfully, doing the mins and rounds correctly. It's seems to me that the problem must be with the logical test at the beginning of the "if" statement.

Please attach your pivot along with the calculations. We cannot spend so much time creating the pivot from scratch to trouble-shoot.

I have a question for you - why do you want to use it on the pivot? Why not do the calculations directly to the data?

We have lost your attachment, can you please attach again?