AnsweredAssumed Answered

Rookie needs help with filemaker 6 - inheritied when uncle died and took on his bis

Question asked by smalenoy on Dec 3, 2008
Latest reply on Dec 3, 2008 by elevatorgirl

Title

Rookie needs help with filemaker 6 - inheritied when uncle died and took on his bis

Post

UK just changed vat rates from 17.5 to 15%.  I easily changed the calculation to 15% for vat, but this changed all existing invoices as well!  Tried to set rate by Invoice Date field as follows:

 

vat field calculation:

 

if (InvoiceDate > "30/11/2008" , subtotal / 100 * 15 , subtotal /100 * 17.5)

 

filemaker accepts the calculation, but only ever returns the 15% calculation?!

 

 

Outcomes