Date of Birth Access expression

[Father John]

We are somewhat new to Access. We are a Monastery and we are trying to go from the 8th century to the 21st.


We have a database that has a date field. We would like to put a calculated field in a form to show the age of the person. I know how to put it in the form but none of the expressions I used work. =date() - [DOB] does not work.
Can someone give us an expression that would do this? Thank You.
God Bless,
Father John

[ajetrumpet]

that expression will most likely give you the number of days between today and their DOB. it doesn't work? you mean, gives the wrong answer? try the following in the control source:

=datediff("yyyy", [DOB], date())

that will not always be reliable though, based on whether or not this year's bday has passed. to be truly reliable, a small function is really needed.

[ssanfu]

Below is a link to a variety of functions created by different developer's to calculate the difference between two dates, which can also be used for Age Calculations.

Maybe this will be of help...


Rogers Access Library

http://www.rogersaccesslibrary.com/f...-dc18595c.html

[bcmarshall]

I didn't see this post until now. If your desire is to create an expression that calculates the age of a person as of today, then I have already done exactly that.

=Int(DatePart("yyyy",Date()-[Forms![YourForm]![DOB])-1900)

[Father John]

Thank you for the more precise formula. The one another user sent me works if you have not passed the birthday. Yours looks like it will work better.

Thank you and God Bless

Father John

[bcmarshall]

It will always return the age today regardless of when the birthday is.

Have fun!