how do i format a expression in Access to show age from a birthdate
R Rolling Hills Helen Apr 15, 2010 #1 how do i format a expression in Access to show age from a birthdate
D Dirk Goldgar Apr 15, 2010 #2 Rolling Hills Helen said: how do i format a expression in Access to show age from a birthdate Click to expand... See this article: http://www.mvps.org/access/datetime/date0001.htm
Rolling Hills Helen said: how do i format a expression in Access to show age from a birthdate Click to expand... See this article: http://www.mvps.org/access/datetime/date0001.htm
J John W. Vinson Apr 15, 2010 #3 On Thu, 15 Apr 2010 08:05:01 -0700, Rolling Hills Helen <Rolling Hills how do i format a expression in Access to show age from a birthdate Click to expand... Age: DateDiff("yyyy", [DOB], Date()) - IIF(Format([DOB], "mmdd") > Format(Date(), "mmdd"), 1, 0)
On Thu, 15 Apr 2010 08:05:01 -0700, Rolling Hills Helen <Rolling Hills how do i format a expression in Access to show age from a birthdate Click to expand... Age: DateDiff("yyyy", [DOB], Date()) - IIF(Format([DOB], "mmdd") > Format(Date(), "mmdd"), 1, 0)
H Hans Up Apr 15, 2010 #4 Rolling said: how do i format a expression in Access to show age from a birthdate Click to expand... See if this page from The access Web has what you want. Date/Time: Calculate Age of a person http://www.mvps.org/access/datetime/date0001.htm
Rolling said: how do i format a expression in Access to show age from a birthdate Click to expand... See if this page from The access Web has what you want. Date/Time: Calculate Age of a person http://www.mvps.org/access/datetime/date0001.htm
