Using "If" etc.

[Roger Anderson]

Hi. I am trying to use an If command to change VAT (Tax) from 17.5% to 15%. I have at the moment:

If(Order Date > 01/12/2008,Line Totals*15/100,Line Totals*17.5/100)

I want to say: If the date is after 01/12/2008 then use 15% as the VAT addition; if not use 17.5%.

Could somebody help me please. Many thanks. Roger

[Raybaudi]

If(

Order Date > Date ( 12 , 1 , 2008 ) , Line Totals * 15/100 ,

Line Totals * 17.5/100

)

Note that this calc is for 6 !

[Roger Anderson]

Thanks very much, Daniele. I will try that. Best wishes. Roger.

[comment]

This is not a good approach overall. Tax rate is data, not part of the schema; it should be looked up from a preference, not hard-coded into a calculation.

[Simon K]

For what its worth - minor point - in UK VAT is rounded down to nearest whole penny too...

Hope this helps

Simon

[Roger Anderson]

Hi. "from a preference". I'm not an expert. Do you mean to put the VAT values in a separate table and look them up and select at the time of writing the invoice? Would appreciate any advice as is for a Charity. Thanks. Roger.

[comment]

Yes, more or less. For a single user, this could be in a global field, but for a hosted solution a separate Preferences table with a single record is preferable.

[Roger Anderson]

Hi again. I'm afraid tha I cannot get your formula to work. Can I use 12/01/2008 as the date format? Or need to put ,. Is If( on the first line alone? Any help really appreciated. Thanks. Roger