How to calculate diffrence between two dates

V

Vianny

In Access expressions, how can I calculate the difference between two dates
in years, months and days?
 
S

Stuart McCall

Vianny said:
In Access expressions, how can I calculate the difference between two
dates
in years, months and days?
Click to expand...

Look up the DateDiff function in help. It does precisely what you want.
 
B

BruceM via AccessMonster.com

Unless something has changed in Access 2007, DateDiff will return one time
interval (years OR months OR days), but not a combination.

Here is a link to code for calculating age in years, months, and days (the
detailed version at the bottome of the page). It can be adapted to work with
the start date and end date of your choice (rather than DOB and the current
date).
http://www.mvps.org/access/datetime/date0001.htm
 
Top