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

Reply via email to