5 Replies Latest reply on Dec 3, 2008 11:02 AM by elevatorgirl

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

    smalenoy

      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?!