Perform Age calculation using Formula Columns in Dataverse / Dynamics 365


The article explains how to perform age calculation using formula columns in Dataverse/Dynamics 365. It suggests creating a new field with the data type "Formula" and formula data type as "Whole Number." The formula used is "RoundDown(DateDiff(birthdate, UTCNow(), TimeUnit.Days) / 365.25, 0)." The DateDiff function calculates the difference in days between the birthdate and the current UTC date. Dividing by 365.25 converts the days to years, taking leap years into account. RoundDown rounds the result to the nearest integer. The article also provides a video and a forum link for further reference.


Article 6m

Login now to access my digest by 365.Training

Learn how my digest works
Features
  • Articles, blogs, podcasts, training, and videos
  • Quick read TL;DRs for each item
  • Advanced filtering to prioritize what you care about
  • Quick views to isolate what you are looking for right now
  • Save your favorite items
  • Share your favorites
  • Snooze items you want to revisit when you have more time