Access Formula Help With VAT

[Atomic]

Hello, I have simple database with the following formula providing a VAT calculation:

=([vatrecovery]+[vatstorage]+[vatextra])*IIf([date out]>#30/11/2008#,0.15,0.175)

That formula accounts for the 15% VAT rate after that date and puts everything before that as 17.5%

However, I need to amend the formula to account for the VAT rate after 1st Jan '10 so that 17.5% is applicable if date out is greater than 31st Dec '10.

Any help would be appreciated

 

[Atomic]

Thanks. The BETWEEN code is what I need. So simple.

Thanks for your help.