954,301 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

MS Access Date Function

I know how to calculate a person's age based on their date of birth but is the reverse possible?
I would like to display a person's DOB in a form using their age. What is the formula for this and how do you implement it?

knight fyre
Junior Poster in Training
88 posts since Feb 2008
Reputation Points: 11
Solved Threads: 1
 

this would have to be done in the properties of the sheet. and you would probable have to create new fields >>>>some thing like Age: (Date()-([DoB])/365.25

bobbyraw
Nearly a Posting Virtuoso
1,324 posts since Oct 2006
Reputation Points: 34
Solved Threads: 103
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You
View similar articles that have also been tagged: