How to calculate age from date of birth in wappler?

[Petri]

Hi!

I’m creating a form where I ask peoples birthday. Is there a way to calculate an age from date an store it as a record to database and then automatically update the age again when the date of birth match with current date?

Thanks,
Petri

[Teodor]

Please check:

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 …