s-news
[Top] [All Lists]

finding differences in dates

To: s-news@lists.biostat.wustl.edu
Subject: finding differences in dates
From: "Data Analytics Corp." <dataanalytics@earthlink.net>
Date: Fri, 05 Oct 2007 10:05:12 -0400
Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=dk20050327; d=earthlink.net; b=BWKTdZ2S4MZnKIKk+vGNEoKds/tnmC23VEl+1L8KFC4W6Pvjxz15uz3HJ5qdlsgP; h=Received:Message-ID:Date:From:User-Agent:MIME-Version:To:Subject:Content-Type:Content-Transfer-Encoding:X-ELNK-Trace:X-Originating-IP;
User-agent: Thunderbird 2.0.0.6 (Windows/20070728)
Good morning,

I have a data frame with an anniversary and expiration date for people belonging to a club. The dates are in mm/dd/yyyy format. I want to find the number of years from anniversary to expiration. I used timeDate(expiration) - timeDate(anniversary) but it looks like I get the number of days. Short of dividing by 365 (which won't allow for leap years), I want a function to find the number of years, preferably to the next largest year (so if one anniversary is 03/01/2006 and expiration is 02/28/2007, then I want years = 1). How do I do this? Any help is appreciated.

Thanks,

Walt Paczkowski

<Prev in Thread] Current Thread [Next in Thread>