Forum home » Delegate support and help forum » Microsoft Access Training and help » Finding period elapsed between two dates
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Finding period elapsed between two dates
Resolved · Low Priority · Version 2003
Reply Mon 2 Mar 2009, 15:49Delegate Jo said...
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?
For upcoming training course dates see: Pricing & availability
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
Tue 10 Mar 2009: Automatically marked as resolved.
|