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 Columns in Dataverse / Dynamics 365”