Stephanie has attended:
Excel Intermediate course
Access Introduction course
Access
How to date diff with a date of birth to calculate the age of the person on a certain future date.
RE: Access
Hello Stephanie
Thank you for your question
If you have the two dates stored in two seperate fields I would create a simple query and use the following:
Expr1: Dates!Date2-Dates!Date1
This will give you the number of days. (In this example I have created a table called Dates with two fields, Date2 holding the later date and Date1 holding the earlier date.)
If you wanted the result in years you could use this and just format the query result field accordingly:
Expr1: ([Dates]![Date2]-[Dates]![Date1])/365
You can also use DATEDIFF formula which is explained in more detail on this link:
http://office.microsoft.com/en-us/access/HP010984861033.aspx
If this resolves your question, please mark it as resolved. If not, please reply with more information.
Kind regards
Cress
