[FYI] How to get someone's age using trigger

[Wikiwi]

I have a use case where I only have the users birthday and I would like to get their age as one of my Fields on my users table. To achieve this, I created a trigger that will compute the age of a user when a new records is inserted or an existing record is updated.

Trigger:

 

Output:

 

[Flowers4Algernon]

Hey, just wanted to share this forum post if you want to achieve this using calc fields: 

 

[Learningforever]

Think this would be more accurate

[RuisiHansamu]

Hello there, this might be useful as anyone's reference: https://howto.caspio.com/faq/reports-datapages/calculated-fields-and-datediff-function/ and https://howto.caspio.com/function-reference/ This article served as my guideline when creating my application.