Jump to content

Date in GST Tax calculation not working?


This topic is 5689 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 5689 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.