AnsweredAssumed Answered

Change tax with out changing past tax

Question asked by Denbeau on Dec 29, 2009
Latest reply on Dec 30, 2009 by RickWhitelaw

Title

Change tax with out changing past tax

Post

I have a small business(florist) and our sales tax has gone up for the fist time in years. from 6.5% to 6.75%. 

I'm using Filemaker 5, I know its old but it works fine for us. The problem is that I'm not sure how to change the tax with out changing all the taxes from the past too. 

Here is may formula the field is a  calulaction.

 

If( Creation Date < Date( 01 , 01 , 1998 ) , Round(Cat quantity tax * .0625, 2) + Round(Cat quantity discount tax * .0625,2), Round(Cat quantity tax * .0650, 2) + Round(Cat quantity discount tax * .0650,2))

 

By the way I didnt set this up so I'm not sure how we got to this point. 

Thanks 

Dennis 

 

Outcomes