Change tax with out changing past tax
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.