Date in GST Tax calculation not working?

[kitesurfer3]

Hi all,

I am new to FM (ex-Access) and have problem calculating Canadian GST Tax (7% before Aug 01 2006 and 6% after Aug 01 2006), based on the date field "Proposal Date"(formatted as 12/25/2003) .

I tried the following 2 ways:

If ( Proposal Date < 8/1/2006 ; 1.07 ; 1.06 )

and

Case ( Proposal Date < 8/1/2006 ; 1.07 ; Proposal Date > 8/1/2006 ; 1.06 ; 1.06)

I am always getting back "1.06", what am I doing wrong?

Or is there a totally different way to accomplish this?

Any help really appreciated,

Emilio

[comment]

See if this helps.

[kitesurfer3]

Thanks for the response but can't see it, I get this

Firefox can't find the server at www.fmforums.comhttp.

[Lee Smith]

You need to use the Date Function, or a second field that is a date.

Example of the Date Function:

Case ( Proposal Date < Date ( 8 ; 1 ; 2006 ) ; 1.07 ; 1.06 )

Example of second date field:

Case ( Proposal Date < Second Date; 1.07; 1.06)

In the link that comments posted, he had explained that a date use like you had, is NOT recognized as a date, but instead a number. Since the "/" is the division operator in FileMaker, you were dividing the number 8 by 2006.

HTH

Lee

[kitesurfer3]

Thank you very much, works great!

[comment]

The link works for me - and I'd still suggest you read it, regarding the inadvisability of hard-coding data into calculations.