Calculate Age from Date of Birth using PowerFx

Calculate Age using Power FX formula

To calculate age using Power FX (the formula language used in Microsoft Power Apps), you can use a formula that calculates the difference between the current date and the date of birth (DOB).

PowerFX Code:

// Assume DateOfBirth is a Date field in your app
Age = DateDiff(DateOfBirth, Today(), Years)

Explanation:

• DateOfBirth: The field that contains the user's birthdate.
• Today(): This function gets the current date.
• DateDiff: This function calculates the difference between two dates.
• Years: The unit for the difference, which will return the age in years.

Example Use Case in a Label Control:

1. Suppose you have a form with a DateOfBirth field.
2. Add a label to your Power App.
3. In the Text property of the label, enter the following formula:

"Age: " & Text(DateDiff(DateOfBirth.SelectedDate, Today(), Years))

This will display the age in years based on the selected date of birth in the DateOfBirth field.

Considerations:

• This method assumes the person has already had their birthday this year. If the birthday hasn't occurred yet in the current year, the result will be one year less.
• If you need to adjust this for precise age calculation (e.g., considering if the birthday has passed this year), you can add more logic to handle that.