Prev: Export Report based on Filter
Next: Bookmark not working on subform
From: Vianny on 2 Mar 2010 03:59
In Access expressions, how can I calculate the difference between two dates
in years, months and days?
From: Stuart McCall on 2 Mar 2010 05:45
"Vianny" <Vianny(a)discussions.microsoft.com> wrote in message
news:9C90CB32-1C04-4124-8FC7-583D62004906(a)microsoft.com...
> In Access expressions, how can I calculate the difference between two
> dates
> in years, months and days?

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


From: BruceM via AccessMonster.com on 2 Mar 2010 07:41
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

Stuart McCall wrote:
>> In Access expressions, how can I calculate the difference between two
>> dates
>> in years, months and days?
>
>Look up the DateDiff function in help. It does precisely what you want.

--
Message posted via http://www.accessmonster.com

 | 
Pages: 1
Prev: Export Report based on Filter
Next: Bookmark not working on subform