Simple If statement (1 Viewer)

[Bentleybelle]

I have created an invoice, pulling the data together from three tables with a query. The business is now registered for Value Added Tax. I have added a text box in the page footer of the invoice with the following expression:

=IIf([InvoiceDate]>31/7/2006,"Vat @ 17.5%"," ")

So that the wording VAT @ 17.5% will appear if the invoice date (which is in the invoice header) is after 31.7.06, otherwise it is left blank. I get this wording whatever the date.

I have also created a similar expression to calculate the VAT on the invoice total, and get a similar result, i.e. it calculates the VAT whatever the invoice date.

Where am I going wrong?

 

[pbaldy]

Try:

=IIf([InvoiceDate]>#31/7/2006#,"Vat @ 17.5%"," ")

 

[Bentleybelle]

Knew it had got to be something simple - many thanks