Date based calculation

[Oyseka]

Hi all, I have to change a database that was developed in 2003 and is on FM 5.5. The basis of the change is that a tax that was applied in 2004 is now being removed so I thought that should be simple, just base the calculation on the dates that the tax was applied to. Wrong It doesn't work, can any one see the error in the calculation.

Case(Invoice Date>01/04/2004 and Invoice Date<01/04/2010; Trace Fees *.14;0) At the moment it just removes the tax from all of the invoices

[comment]

See:

http://fmforums.com/forum/showpost.php?post/236847/

A better solution would be to find the relevant invoices and enter .14 into a tax rate field - then change the calculation to use that field.