Solved

# Calculate A Persons Age

Posted on 2003-11-20
397 Views
How do i compute a persons age? if there's a leap year?
0
Question by:karmicrepublic
• 3

LVL 13

Expert Comment

ID: 9795009
0

LVL 13

Accepted Solution

AlbertaBeef earned 250 total points
ID: 9795022
This is from a PAQ:  http://www.experts-exchange.com/Programming/Programming_Languages/Visual_Basic/Q_20626567.html

Private Sub Command1_Click()
'2003 05 26_
'1976 10 31
'--------------
'     26 06 25

Dim dtm1 As Date
Dim dtm2 As Date
Dim intYear As Integer
Dim intMonth As Integer
Dim intDay As Integer

dtm1 = #5/26/2003#
dtm2 = #10/31/1976#

intYear = Abs(Year(dtm2) - Year(dtm1))
If (Month(dtm1) < Month(dtm2)) Or ((Month(dtm1) = Month(dtm2)) And (Day(dtm1) < Day(dtm2))) Then
intYear = intYear - 1
End If

If Month(dtm1) > Month(dtm2) Then
intMonth = Month(dtm1) - Month(dtm2)
Else
intMonth = (12 - Month(dtm2)) + Month(dtm1)
If Day(dtm1) < Day(dtm2) Then
intMonth = intMonth - 1
End If
End If

If Day(dtm1) > Day(dtm2) Then
intDay = Day(dtm1) - Day(dtm2)
Else
intDay = (30 - Day(dtm2)) + Day(dtm1)
End If

MsgBox intYear & "-" & intMonth & "-" & intDay
End Sub
0

LVL 14

Expert Comment

ID: 9795027
test for leap year

Public Function IsLeapYear(Yr As Integer) As Boolean

'Set default return value
IsLeapYear = False

'If year is divisible with four then it's a leap year, unless
'is divisible by 100 but not by 400...
If Yr Mod 4 = 0 Then

IsLeapYear = True

If Yr Mod 100 = 0 Then

If (Yr Mod 400) Then IsLeapYear = False

End If

End If

End Function
0

LVL 13

Expert Comment

ID: 9795095
Why the 'B' grade?  I supplied two working links and one with source code.
0

## Featured Post

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…