Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.
Juggernaut

New Canadian GST Calculation

goldensyd
in Calculation Engine (Define Fields)

Featured Replies

My existing small biz file calculates GST @ 7%, but as of July 1, 2006 GST is now 6%.

Right now the calculation is simply Total Sale GST=Total Sale * .07. How do have Total Sale GST check the Date Sold field before applying the tax?

Total Sale GST =

If(Sale Date < 7/1/2006;

Total Sale * .07;

Total Sale * .06)

  • Author

Thanks sbg2. I tried

Total Sale GST=

If(Date Sold < 7/1/2006, Total Sale * .07, Total Sale * .06)

but the calculation does not seem to be reading the date? I get GST calculated at 6% regardless of the Date Sold. I did sample records with the value of Total Sale as 1.00 and changed the Date Sold to before and after July 1st but Total Sale GST is always calculated as $0.06?

Your date format is incorrect. 7/1/2006 is basically dividing 7 by 2006. Use the Date() function when working with literal dates in a calc.

  • Author

Thanks, ender! Very obvious when explained!

This was the final calculation that worked

Total Sale GST=

If(Date Sold < Date (7,1,2006), Total Sale * .07, Total Sale * .06)

Very much appreciate the assistance of this forum!

Create an account or sign in to comment

https://fmforums.com/topic/45145-new-canadian-gst-calculation/
Go to topic listing

Important Information

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

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.