Jo has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Excel Intermediate course
Finding period elapsed between two dates
whats the easiest way to find how much of a period (days) has elapsed between 2 specific dates?
RE: 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
