What about using a formula: If date =>1/12/2008 then VAT = 15% else VAT = 17.5%
Converted to FileMaker 6 speak. Sorry I'm on version 9 which, which, for a definition of VAT could give something like "If ( TodaysDate „ 1/12/2008 ; 15 ; 17 )" you would need to define TodaysDate to be "Get ( CurrentDate )" or similar. I believe dates are a little easier to handle in Ver 9. Good luck Paul Owen > From: Rob Beattie <[EMAIL PROTECTED]> > Reply-To: <[email protected]> > Date: Sun, 30 Nov 2008 17:46:35 +0000 > To: <[email protected]> > Subject: [sussex_mug] FileMaker > > > Any FileMaker experts care to help with what > - to them - is probably a simple question? I > ahem, 'built' my own accounts database with > FileMaker and it's been running OK for years. > I now have to change the VAT calculation for > tomorrow so that when I type in the amount, > it calculates the VAT for me automatically. > I've worked out how to do it (it's been a > long time) but of course, it then changes the > calculation for all my existing database > entries. Is there any easy way to make it > leave the existing 17.5% entries and only > apply 15% from tomorrow? I'm using FileMaker > Pro 6. Obviuously I don't want to create a > separate, new database because that'll cause > problems at year end. > > TIA > > rob > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Sussex Mac User Group" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/smug?hl=en-GB -~----------~----~----~----~------~----~------~--~---
