is there any way to calculate age from 2 date fields in years

See this function:
http://allenbrowne.com/func-08.html

It takes 2 dates, and gives the age (in whole years) as of a particular
date.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"skrysiak" <(E-Mail Removed)> wrote in message
news6A7BECA-C98C-4A02-AC2D-(E-Mail Removed)...
> is there any way to calculate age from 2 date fields in years

skrysiak wrote:
> is there any way to calculate age from 2 date fields in years

For the age in years from dt1 to dt2 I use (VBA):

intCurrentAge = Int(Format(dt2, "yyyy.mmdd") - Format(dt1, "yyyy.mmdd"))

In SQL:

SELECT Int(Format(Date(), "yyyy.mmdd") - Format([BirthDate],
"yyyy.mmdd")) As CurrentAge FROM MyTable WHERE BirthDate IS NOT NULL;

It makes use of a mathematical concept known as a Poset (Partially
Ordered Set) relationship where the relative order of dates making up
the actual fraction of years is the same as the numerical order of the
pseudodecimal representation of those dates given by the format function.

James A. Fortune
(E-Mail Removed)

"James A. Fortune" wrote:

> skrysiak wrote:
> > is there any way to calculate age from 2 date fields in years
>
> For the age in years from dt1 to dt2 I use (VBA):
>
> intCurrentAge = Int(Format(dt2, "yyyy.mmdd") - Format(dt1, "yyyy.mmdd"))
>
> In SQL:
>
> SELECT Int(Format(Date(), "yyyy.mmdd") - Format([BirthDate],
> "yyyy.mmdd")) As CurrentAge FROM MyTable WHERE BirthDate IS NOT NULL;
>
> It makes use of a mathematical concept known as a Poset (Partially
> Ordered Set) relationship where the relative order of dates making up
> the actual fraction of years is the same as the numerical order of the
> pseudodecimal representation of those dates given by the format function.
>
> James A. Fortune
> (E-Mail Removed)
>

How would the sql look if current age I want to show 60 years,10 months,3
days

MaRSMAN wrote:
>
> "James A. Fortune" wrote:
>
>
>>skrysiak wrote:
>>
>>>is there any way to calculate age from 2 date fields in years
>>
>>For the age in years from dt1 to dt2 I use (VBA):
>>
>>intCurrentAge = Int(Format(dt2, "yyyy.mmdd") - Format(dt1, "yyyy.mmdd"))
>>
>>In SQL:
>>
>>SELECT Int(Format(Date(), "yyyy.mmdd") - Format([BirthDate],
>>"yyyy.mmdd")) As CurrentAge FROM MyTable WHERE BirthDate IS NOT NULL;
>>
>>It makes use of a mathematical concept known as a Poset (Partially
>>Ordered Set) relationship where the relative order of dates making up
>>the actual fraction of years is the same as the numerical order of the
>>pseudodecimal representation of those dates given by the format function.
>>
>>James A. Fortune
>>(E-Mail Removed)
>>
>
>
> How would the sql look if current age I want to show 60 years,10 months,3
> days

Try:

http://groups.google.com/group/micro...c1e78c092cdd13

Post back if you have trouble seeing how to follow that suggestion.

James A. Fortune
(E-Mail Removed)