Is it possible to build a query that converts a birthdate to current age? Access 2000 Thanks.
D Dori Oct 7, 2004 #1 Is it possible to build a query that converts a birthdate to current age? Access 2000 Thanks.
R Rick B Oct 7, 2004 #2 Age: DateDiff("yyyy",[DOB],DAte()) - IIF(Format([DOB],"mmdd")>Format(Date()."mmdd"),1,0)
V Van T. Dinh Oct 7, 2004 #3 You can use the function from The Access Web: http://www.mvps.org/access/datetime/date0001.htm in the Query to calculate the age from the BirthDate.
You can use the function from The Access Web: http://www.mvps.org/access/datetime/date0001.htm in the Query to calculate the age from the BirthDate.
