divide days by 30.42 to get damn-near-exact months.
should provide a fractional return as well -- e.g., 233 days / 30.42 = 7.67
months (7 and 2/3rds)
Warranties are besed on precise dates, so I would imagine they want months and
days left??
233 / 30.42 = 7 and 0.67 months
= 7 (30.42*.67 = 20.38 days ) and round this up to even days -
7 months and 21 days
----- Original Message -----
From: Dan Goldberg
To: RBASE-L Mailing List
Sent: Thursday, August 26, 2010 1:02 PM
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
--
This message has been scanned for viruses and
dangerous content by Our MailScanner, and is
believed to be clean.
