How to compute AGE from DOB

[enyonam]

1. I have a query that lists users from a table. One of the table columns is Date of Birth

2. On the page I display the list, I want an additional column that will show a computed AGE of each user from the DoB in the table.

3. Based on the computed Age, I want to add another column that shows a Qualified or Disqualified Status.

How do I achieve this?

[mebeingken]

Hi Francis,

If you do a quick google search you’ll find an sql statement that will add another column which is the age based on dob. Make sure to find one that deals with leap years. You can then use a custom query action to execute it, and it will just be part of your db result set. Similarly, you can add the other calculation.

—Ken

[zitroware]

@enyonam, if you don’t want to do it via server side query, you can also do it via front-end on your page.
#2. you just add a table header (i.e. <th>) for the static column name, and then add a new row (i.e. <td>) for the calculation with your formula. You can use the Data Formatter for the difference in date. You can refer from this post: Time posted

#3. also add another table header and another <td> for the calculation.

[Teodor]

Hi @enyonam
Here's a quick tutorial explaining how to calculate age from date of birth:

Calculating Age from Date of Birth

Usually we store users dates of birth in our database table, in a DATE field type. You can easily calculate the age of your users, using the App Connect Data Formatter component on your page. We created a dynamic table, displaying the data from our database and one of the columns displays the dates of birth. It’s currently displaying the dates in the default database format, but you can format them as you need (that’s not the topic of this tutorial) : [Screenshot_36] The first thing we need…

[enyonam]

Thank you @Teodor and everyone. I will attempt @Teodor the solution and revert .