how to calculate age using date of birth

Carlos kambui

11y249Visual Basic .NET

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Upendra Pratap Shahi11y ago
accept the solution for better help!!!!!!!!!!!
0
Rajeesh Menoth11y ago
Welcome..:)
0
Carlos kambui11y ago
thank code works properly
0
Sabyasachi Mishra11y ago
declare @age float
select @age=DATEDIFF(DAY,DOB,GETDATE()) from Table
select @age/365 as [Year] from Table
--------
Here DOB is your dateofbirth column in SQL and Table is your SQL Table
0
Upendra Pratap Shahi11y ago
hello dear,

DateTime dob = Convert.ToDateTime("1988/12/20");
string text = CalculateYourAge(dob);

static string CalculateYourAge(DateTime Dob)
{
DateTime Now = DateTime.Now;
int Years = new DateTime(DateTime.Now.Subtract(Dob).Ticks).Year - 1;
DateTime PastYearDate = Dob.AddYears(Years);
int Months = 0;
for (int i = 1; i <= 12; i++)
{
if (PastYearDate.AddMonths(i) == Now)
{
Months = i;
break;
}
else if (PastYearDate.AddMonths(i) >= Now)
{
Months = i - 1;
break;
}
}
int Days = Now.Subtract(PastYearDate.AddMonths(Months)).Days;
int Hours = Now.Subtract(PastYearDate).Hours;
int Minutes = Now.Subtract(PastYearDate).Minutes;
int Seconds = Now.Subtract(PastYearDate).Seconds;
return String.Format("Age: {0} Year(s) {1} Month(s) {2} Day(s) {3} Hour(s) {4} Second(s)",
Years, Months, Days, Hours, Seconds);
}
kindly check this.. this is run code by me...

If this works for you kindly accept the answer...

Happy Coding...

0
Rajeesh Menoth11y ago
Hi,
DateTime today = DateTime.Today; int age = today.Year - bday.Year; if (bday > today.AddYears(-age)) age--;
Ref : http://stackoverflow.com/questions/9/how-do-i-calculate-someones-age-in-c
0