goldensyd Posted August 2, 2006 Share Posted August 2, 2006 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? Link to comment Share on other sites More sharing options...
sbg2 Posted August 3, 2006 Share Posted August 3, 2006 Total Sale GST = If(Sale Date < 7/1/2006; Total Sale * .07; Total Sale * .06) Link to comment Share on other sites More sharing options...
goldensyd Posted August 3, 2006 Author Share Posted August 3, 2006 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? Link to comment Share on other sites More sharing options...
Ender Posted August 3, 2006 Share Posted August 3, 2006 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. Link to comment Share on other sites More sharing options...
goldensyd Posted August 4, 2006 Author Share Posted August 4, 2006 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! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6490 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 accountSign in
Already have an account? Sign in here.
Sign In Now