I need to calculate the age in number of years of a member from a numeric field that holds the birth year of the member. How to do?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
Photo of Bob


  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,074 Points 20k badge 2x thumb
Because you are saving the [Year] instead of date of birth you could be off 364 days in your age calculation. However here is the formula you can use:

Year(Today()) - [Year]