Convert D.O.B into Age

Question

0.00/5 (No votes)

See more:

Hi there.

Im doing a c# desktop application and trying to convert a "Date Of Birth" into an "Age".

Problem is that I retrieve the "Date Of Birth" from an SQL SERVER 2008 server as a nvarchar and save it in C# as a string.

Any help?

Posted 14-Sep-11 10:24am

DJAppleboy

Add a Solution

Comments

TRK3 14-Sep-11 16:54pm

What is the format of the data in the database? Are they all the same format or do they vary?

4 solutions

Solution 2

Try

C#

public static int GetAge(string strDate)
     {
         DateTime birthDate = DateTime.Parse(strDate);
         DateTime n = DateTime.Now; 
         int age = DateTime.Now.Year - birthDate.Year;

         if (n.Month < birthDate.Month || (n.Month == birthDate.Month && n.Day < birthDate.Day))
             age--;

         return age;
     }

Posted 14-Sep-11 11:27am

RaviRanjanKr

Solution 3

Or as an extension method:

C#

public static class ExtensionMethods
{
    public static int Age(this DateTime dt)
    {
        TimeSpan span = DateTime.Now.Date - dt.Date;
        return Math.Min(1, span.TotalDays % 365);
    }
}

Posted 14-Sep-11 12:14pm

#realJSOP

Comments

AspDotNetDev 14-Sep-11 19:51pm

Not sure this would be 100% accurate, on account of leap years.

#realJSOP 15-Sep-11 4:47am

I think it would be close enough if we're talking about the age of a human, and not the age of something like the earth.

Solution 4

The exact age depends on the requesting moment. You have to consider days-per-month and leap years.

The DateDiff class of the Time Period Library for .NET[^] is considering these aspects:

C#

// ----------------------------------------------------------------------
public int Age( DateTime dob )
{
  return new DateDiff( dob ).ElapsedYears;
} // Age

Posted 15-Sep-11 1:59am

Jani Giannoudis

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Morgs Morgan · Accepted Answer · 2011-09-14T11:04:00

Solution 1

Try this:

C#

String dob = "2010/01/01";//read from your database to get dob, just an example
DateTime dateOfBirth = DateTime.Parse( dob );
Int32 age = DateTime.Now.Year - dateOfBirth.Year;
//age=1 in above code

Good luck

Posted 14-Sep-11 11:04am

Morgs Morgan