D dspinner Registered User. Local time Today, 21:37 Joined Sep 26, 2002 Messages 16 Oct 21, 2002 #1 This is a simple question from a relative newbie... What is the best method to calculate someone's age based on their birthdate? It seems i get a fraction it rounds UP
This is a simple question from a relative newbie... What is the best method to calculate someone's age based on their birthdate? It seems i get a fraction it rounds UP
R rpadams Registered User. Local time Today, 16:37 Joined Jun 17, 2001 Messages 111 Oct 21, 2002 #2 Do a search on "Age calculation." It's been covered in great detail on this forum.
R. Hicks AWF VIP Local time Today, 15:37 Joined Dec 23, 1999 Messages 618 Oct 21, 2002 #3 DateDiff("yyyy", DOB, Date) + (Date < DateSerial(Year(Date), Month(DOB), Day(DOB))) "DOB" should be the Date of Birth information. HTH RDH
DateDiff("yyyy", DOB, Date) + (Date < DateSerial(Year(Date), Month(DOB), Day(DOB))) "DOB" should be the Date of Birth information. HTH RDH
R raskew AWF VIP Local time Today, 15:37 Joined Jun 2, 2001 Messages 2,731 Oct 22, 2002 #4 Ricky- That is a truly elegant solution! At first, I was asking myself "...where is he going with this?" Took awhile to see the marvelous logic. I'm in awe! Bob
Ricky- That is a truly elegant solution! At first, I was asking myself "...where is he going with this?" Took awhile to see the marvelous logic. I'm in awe! Bob
