The age of a person

You can quickly evaluate the age of a person using the following function:

Function Age(BirthDate As Date, Optional CurrentDate As Variant) As Integer    If IsMissing(CurrentDate) Then CurrentDate = Now    Age = Year(CurrentDate) - Year(BirthDate)End Property

If you omit the second argument, the age is evaluate at the current time, but specifying it you can evaluate the age at any given date.

The above function, however, evaluates the age of a person in a “informal” way. To see what this means, run the following code:

Print Age(#6/1/1980#, #1/1/2000#)     ' returns 20

It is evident that the function actually returns the age of the person on his/her birthday in the current year, but the actual age could be less than this value. To evaluate the “exact” age, use the following variant:

Function Age(BirthDate As Date, Optional CurrentDate As Variant, _    Optional ExactAge As Boolean) As Integer    If IsMissing(CurrentDate) Then CurrentDate = Now    Age = Year(CurrentDate) - Year(BirthDate)        If ExactAge Then        ' subtract one if this year's birthday hasn't occurred yet        If DateSerial(Year(CurrentDate), Month(BirthDate), _            Day(BirthDate)) > CurrentDate Then            Age = Age - 1        End If    End IfEnd Property

Share the Post:
Share on facebook
Share on twitter
Share on linkedin


The Latest

iOS app development

The Future of iOS App Development: Trends to Watch

When it launched in 2008, the Apple App Store only had 500 apps available. By the first quarter of 2022, the store had about 2.18 million iOS-exclusive apps. Average monthly app releases for the platform reached 34,000 in the first half of 2022, indicating rapid growth in iOS app development.

microsoft careers

Top Careers at Microsoft

Microsoft has gained its position as one of the top companies in the world, and Microsoft careers are flourishing. This multinational company is efficiently developing popular software and computers with other consumer electronics. It is a dream come true for so many people to acquire a high paid, high-prestige job

your company's audio

4 Areas of Your Company Where Your Audio Really Matters

Your company probably relies on audio more than you realize. Whether you’re creating a spoken text message to a colleague or giving a speech, you want your audio to shine. Otherwise, you could cause avoidable friction points and potentially hurt your brand reputation. For example, let’s say you create a