Here in Canada, they are lowering the GST/VAT from 6% to 5%. I need to redo the calculation for the field based on whether the quotation/workorder/invoice was made before or after midnight tonight.

I was trying something like this but it's not working, any help is always appreciated.

Case(GetAsNumber(GSTRATE) < GetAsNumber(Date(1;1;2008)); GSTRATE = .06 ; GSTRATE = .05)

Hmm, I'm not sure why you're comparing your GSTRATE with 1/1/2008, so unless I'm missing something you'll need to change that.

You need to consider the 'date' of the when the invoice is made - whether it's the record creation time or something (auto-)filled in by the user. Regardless of how that date is set, you need to use that field (I called it InvoiceDate) in the calc below:

Case( InvoiceDate ≥ Date(1;1;2008); .06 ; .05)

This also assumes that all your users are in the same time zone as your server; if they're not you may have further decisions to make if the date that matters is where the server is located, not where the user is.

Isn't New Year's Day a public holiday in Canada? Maybe you can just reset the GSTRATE tomorrow.

I am presuming that your Invoices are recorded with the prevailing GSTRATE at the time of creation - if not you should correct the situation pronto. It is important to have financial records using "fixed" data - that is any variable items should be stored with the record rather than relying upon calculations or, worse still, related data.

Edited December 31, 200718 yr by Guest

With Soren's help, I did

Case( InvoiceDate ≥ Date(1;1;2008); .06 ; .05)

Simply to be sure that any outstanding invoices (that are generated possibly from pre 2008 quotes) have the right number Happy New Year to everyone, thank you for all your ongoing help

Salut

This is not a good method, IMHO. Changing the tax rate should be in the province of the user - it need not require the developer's intervention. See:

http://www.fmforums.com/forum/showtopic.php?tid/188836/