Re: Calculate Age

Posted by Bruce Weaver on Nov 29, 2012; 10:51pm
URL: http://spssx-discussion.165.s1.nabble.com/Calculate-Age-tp5716523p5716525.html

Adding to Gene's advice, in the Transform - Compute dialog, click on Date Arithmetic in the Function Group box, and Datediff will be listed in the Functions and Special Variables box.  Click on it for more info.

Maguin, Eugene wrote

Look at the DateDiff function, which is available, I expect, as part of the Compute menu  and also documented in the help file and the syntax reference.
DateDiff is the new way and has more flexibility. One old way, which gives age in years and decimal parts, is
Compute age=(date1-date2)/(3600*24*365.25).
Gene Maguin

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Albert Calhoun
Sent: Thursday, November 29, 2012 4:48 PM
To: [hidden email]
Subject: Calculate Age

How would i calculate age in the following format:
02-Nov-1990 as of the following date 15-Oct-2012

=====================
To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD