What is the correct formula to show someone's age based on the birthdate field?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

I'm looking for a simple formula to show a person's age comparing today's date to the Birthdate field in my Contact record.  Ex DOB is 11/20/1938.  Today is Nov 11 so he is 76 but on Nov 20 he will be 77.

Photo of Deborah

Deborah

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,448 Points 50k badge 2x thumb
This  should work

var date DOB = [DOB];

Year(Today())-Year($DOB)
-
If(
Month(Today())<Month($DOB)
or
(Month(Today())=Month($DOB) and Day(Today())<Day($DOB)),1,0)