G
Guest
how to tell access what age somebody has. by using birthdate and systemdate?
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.
P
Pieter Wijnen
Check the DateDiff Function
HTH
Pieter
HTH
Pieter
systemdate?jos said:how to tell access what age somebody has. by using birthdate and
D
Douglas J. Steele
DateDiff("yyyy", [Birthdate], Date()) - _
IIf(Format(Date(), "mmdd") < Format([Birthdate], "mmdd"), 1, 0)
The first part gives the difference in years between the 2 dates.
Unfortunately, the DateDiff function is a little too literal: it sees
2003/12/31 and 2004/01/01 as being one year apart, so it's necessary to add
the second part, which checks to see whether the birthday has already
occurred this year. If it has not, you subtract 1 from the value computed by
DateDiff.
--
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
IIf(Format(Date(), "mmdd") < Format([Birthdate], "mmdd"), 1, 0)
The first part gives the difference in years between the 2 dates.
Unfortunately, the DateDiff function is a little too literal: it sees
2003/12/31 and 2004/01/01 as being one year apart, so it's necessary to add
the second part, which checks to see whether the birthday has already
occurred this year. If it has not, you subtract 1 from the value computed by
DateDiff.
--
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
systemdate?jos said:how to tell access what age somebody has. by using birthdate and
V
Van T. Dinh
See The Access Web:
http://www.mvps.org/access/datetime/date0001.htm
--
HTH
Van T. Dinh
MVP (Access)
http://www.mvps.org/access/datetime/date0001.htm
--
HTH
Van T. Dinh
MVP (Access)
systemdate?jos said:how to tell access what age somebody has. by using birthdate and