Power Platform Community Forum Thread Details

Hello! I'm trying to add an Age column to my Customers table. I have each customer's date of birth in a column DOB as a date.

My primary goal is to have age display accurately as a year, and as a whole number, but so far I have not been able to do both at once.

The Age column is a calculated text column with the following formula:

DiffInMonths(velrada_dob, Now()) / 12

It returns the correct year, but has a decimal, which I do not want.

The Age in Years column is a calculated decimal column, with 0 decimal places and with the following formula:

DiffInMonths(velrada_dob, Now()) / 12

It returns the rounded year, which is not the correct age as per the date of birth 50% of the time. It is the year closest to the date of birth. Sometimes it's correct (line 3), and sometimes it's wrong (line 1). Same thing happens with the same formula on a whole number column.

The Age in Years 2 column is a formula column (decimal automatically) with the following formula:

Trunc(DateDiff(DOB,'Now Datetime')/365)

It has the correct year, and the decimal places are 0, but they're still there! That's the only problem, I want it to be a whole number. Same things happen with the following:

RoundDown(DateDiff(DOB,'Now Datetime')/365)

Int(DateDiff(DOB,'Now Datetime')/365)

What can i do to get a rounded down value without decimal places?

Categories:

Microsoft Dataverse with Power Apps