Finding period elapsed between two dates

Hello Jo
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