Need to calculate elapsed time in years

[Fred Worthington]

Greetings:

My Form contains a "Birthday" Field. I want to include an additional field
that displays the individuals Age by calculating the difference in years
between the birthdate and the current date. So far I have tried this
syntax: =DateDiff("yyyy",[Birthday],[Now()]), but I still get a #Name? in
my Age Field. Can anyone tell me the current formula for this Field?

Thanks . . . Fred

 

[Rick B]

This is posted ALLLLL the time. Did you try doing a search first?


DateDiff("yyyy",[Birthdate],Date())+(Format([Birthdate],"mmdd")>Format(Date(
),"mmdd"))









Rick B

 

[Rick B]

Note that doing it the way you had posted would not take into account if the
person's birthday had passed. If my birthday was May 1, 1974 You would have
seen that I am 30 years old on February of 2004 or on December of 2004.
That's why you can't simply subtract the years.

Rick B

This is posted ALLLLL the time. Did you try doing a search first?


DateDiff("yyyy",[Birthdate],Date())+(Format([Birthdate],"mmdd")>Format(Date(
),"mmdd"))









Rick B

Greetings:

My Form contains a "Birthday" Field. I want to include an additional field
that displays the individuals Age by calculating the difference in years
between the birthdate and the current date. So far I have tried this
syntax: =DateDiff("yyyy",[Birthday],[Now()]), but I still get a #Name? in
my Age Field. Can anyone tell me the current formula for this Field?

Thanks . . . Fred

 

[Fred Worthington]

Thanks Rick, that did the trick. Unlike other sources that I tried for this
solution, yours was right on the money.

Thanks . . . Fred

This is posted ALLLLL the time. Did you try doing a search first?


DateDiff("yyyy",[Birthdate],Date())+(Format([Birthdate],"mmdd")>Format(Date(
),"mmdd"))









Rick B

Greetings:

My Form contains a "Birthday" Field. I want to include an additional field
that displays the individuals Age by calculating the difference in years
between the birthdate and the current date. So far I have tried this
syntax: =DateDiff("yyyy",[Birthday],[Now()]), but I still get a #Name? in
my Age Field. Can anyone tell me the current formula for this Field?

Thanks . . . Fred