S
skrysiak
is there any way to calculate age from 2 date fields in years
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Allen Browne
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.
http://allenbrowne.com/func-08.html
It takes 2 dates, and gives the age (in whole years) as of a particular
date.
J
James A. Fortune
skrysiak said: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
[email protected]
M
MaRSMAN
James A. Fortune said:skrysiak said: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
[email protected]
How would the sql look if current age I want to show 60 years,10 months,3
days
J
James A. Fortune
MaRSMAN said::
skrysiak said: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
[email protected]
How would the sql look if current age I want to show 60 years,10 months,3
days
Try:
http://groups.google.com/group/microsoft.public.access/msg/d7c1e78c092cdd13
Post back if you have trouble seeing how to follow that suggestion.
James A. Fortune
[email protected]