Rookie needs help with filemaker 6 - inheritied when uncle died and took on his bis
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?!