G Guest Nov 17, 2004 #2 Hi, The Datediff function should be able to figure out the age up to day. Datediff("yyyy", DOB, Now())
Hi, The Datediff function should be able to figure out the age up to day. Datediff("yyyy", DOB, Now())
R Rick B Nov 17, 2004 #3 That does not work. It does not take into account if the birthdate has passed this year, or is coming up. You would use... DateDiff("yyyy",[Birthdate],Date())+(Format([Birthdate],"mmdd")>Format(Date( ),"mmdd")) Please note: This question is asked in this newsgroup often. In the future, you might try doing a search before posting your question. Rick B Hi, The Datediff function should be able to figure out the age up to day. Datediff("yyyy", DOB, Now()) Click to expand... age.
That does not work. It does not take into account if the birthdate has passed this year, or is coming up. You would use... DateDiff("yyyy",[Birthdate],Date())+(Format([Birthdate],"mmdd")>Format(Date( ),"mmdd")) Please note: This question is asked in this newsgroup often. In the future, you might try doing a search before posting your question. Rick B Hi, The Datediff function should be able to figure out the age up to day. Datediff("yyyy", DOB, Now()) Click to expand... age.
