Calculate Age in Power Apps

(1) Share

Report

Posted on by Radoslavov

817

Hi All,

It's being quite some time since my last question here and I'm seeking all professional's assistance here.

I'm building a Medical App that requires the Patient's age.

What is required from the Patient to enter is just his Sex and Date of Birth, the age will be calculated automatically using Todays Data and the Birthday Data input from the Calendar

This is how the screen looks like:

The Age number is actually the main information required for the app, so this file will be hidden from the user anyway.

Any suggestions on how to calculate the Age of a Patient?

I've tried this: DateDiff(Today(),userbirthdate.SelectedDate)

but I got the difference in days

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (2)

Verified answer

eka24 20,923 on at

Like (10)

Report
Copy link

Link copied!

Consider this:

DateDiff(StartDatePicker.userbirthdate,Today(),Years)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

It’s not as simple as it looks because age is typically rounded down. I did it for cds here https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Calculating-age-in-CDS-entity/td-p/495528

Was this reply helpful? Yes No
Radoslavov 817 on at

Like (0)

Report
Copy link

Link copied!

This is working,I just change the formula slightly to remove the age rounding as 29 years and 9 months even if it's close to 30, the medical records think otherwise when it comes to accuracy.

Was this reply helpful? Yes No
Verified answer

MartinVasek 30 on at

Like (8)

Report
Copy link

Link copied!

This solution looks incorrect!

It returns difference between current year and year of birth but NOT age.
For example if today is 3rd of February 2022 and someone was born on 1st of January 2000, it will return the same result as for someone born on 3rd of March 2000. Ages are obviously different (22 and 21) but for both it returns 22.

For return of age I recommend to use this:
If(DateDiff(Today(), Date(Year(Now()), Month(birth), Day(birth))) <= 0, DateDiff(birth, Today(), Years), DateDiff(birth, Today(), Years) - 1)

What it does:
It checks if desired date's day and month are lower or equal to today's day and month and if so it makes difference between years. Otherwise it makes difference between this year and desired date year and deducts 1 (because this person didn't have birthday this year yet).

Was this reply helpful? Yes No
PapithaSekar1 100 on at

Like (0)

Report
Copy link

Link copied!

If(DateDiff(Today(), Date(Year(Now()), Month(birth), Day(birth))) <= 0, DateDiff(birth, Today(), Years), DateDiff(birth, Today(), Years) - 1)
this formula is working

Was this reply helpful? Yes No
Epzone 3 on at

Like (0)

Report
Copy link

Link copied!

DateDiff(DateTimeValue(SelectedDate),Now(),Years)

Was this reply helpful? Yes No
fatima12345 2 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No