Perform Age calculation using Formula Columns in Dataverse / Dynamics 365

Below we have created a new field of Data Type Formula and Formula Data Type as Whole Number Specify the following formula. RoundDown(DateDiff(birthdate, UTCNow(), TimeUnit.Days) / 365.25, 0) Below we see the field in action. UTC current date is 10th Wednesday July 2024 for the below example. Also checkout the helpful video – and the … Continue reading “Perform Age calculation using Formula…

Continue Reading Nishant Rana’s Article on their blog

Perform Age calculation using Formula Columns in Dataverse / Dynamics 365

Below we have created a new field of Data Type Formula and Formula Data Type as Whole Number Specify the following formula. RoundDown(DateDiff(birthdate, UTCNow(), TimeUnit.Days) / 365.25, 0) DateDiff calculates the difference in days between birthdate and current UTC Date. Dividing by 365.25 takes care of converting the days to years, considering the leap year…

Blog Syndicated with Nishant Rana’s Permission

Author: Nishant Rana

Share This Post On
Share via
Copy link
Powered by Social Snap