That sounds interesting. I might give that a try. Thanks Dan Goldberg _____
From: [email protected] [mailto:[email protected]] On Behalf Of Gary Wendike Sent: Thursday, August 26, 2010 1:32 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: month calculations You could also take the number of day elapsed on the warranty divided by the number of days of warranty and multiply by number the months for the warranty. Gary _____ From: jan johansen <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Thu, August 26, 2010 12:15:14 PM Subject: [RBASE-L] - Re: month calculations Dan, A rudimentary calculation would be to divide the days left by 30.5. It would give you a rough idea of the months left in a warranty. Jan -----Original Message----- From: "Dan Goldberg" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Thu, 26 Aug 2010 10:02:27 -0700 Subject: [RBASE-L] - month calculations I am perplexed on a calculation I need to do. I need to find out how many months is left in a warranty. So it would be today minus the sold date. I can get the amount of days left in the warranty by just subtracting them but they want the amount of months left. I am looking at the functions but am hitting a brain lock on how to calculate the months left. Help!! Dan Goldberg
