D danassef New member Local time Today, 17:22 Joined Dec 28, 2006 Messages 7 Dec 29, 2006 #1 I'm trying to make a query that takes the DOB from my table and converts it to an age. I have tried to write an expression =datediff ("yyyy", now(), [DOB]) in the criteria section of an expression I called AGE.
I'm trying to make a query that takes the DOB from my table and converts it to an age. I have tried to write an expression =datediff ("yyyy", now(), [DOB]) in the criteria section of an expression I called AGE.
E EMP Registered User. Local time Today, 22:22 Joined May 10, 2003 Messages 574 Dec 29, 2006 #2 Age: DateDiff("yyyy",[DOB],Date()) +(Format(Date(),"mmdd")<Format([DOB],"mmdd")) In query Design View, put it in the Field: row, not the Criteria: row. ^ Last edited: Dec 29, 2006
Age: DateDiff("yyyy",[DOB],Date()) +(Format(Date(),"mmdd")<Format([DOB],"mmdd")) In query Design View, put it in the Field: row, not the Criteria: row. ^
