AppGini Community Forums

Hello,

maybe someone can give me a code for a "calculated field" on how to calculate an age from a date of birth. I tried different Selects, but unfortunately they don't work in the AppGini field "Calculated field.

Thank you very much, Kai

look here

viewtopic.php?t=1082#p2546

Hi,

Thanks a lot. I've already looked at the site. but I have no idea what to put in the "Calculated field".

These codes are for hooks. But what of that comes in the "calculated field" field in the appgini ide?

My fields are: "date_of_birth" and "age"

Thanks very much, Kai

Hi,

you can try
assuming your pk is id

Hi,

thank you so much for help

I tried it out. But the code has no effect on the "age" field.

select TIMESTAMPDIFF(year,date_of_birth,NOW()) as age from Employees where id=#ID#

The field names should be correct

Hi,
can you post a screenshot of your tabledefinition and what you put into the calculated field.

Hi, sorry, I just saw a typo in the code.

Try

select TIMESTAMPDIFF(year,date_of_birth,NOW()) as age from Employees where id=%ID%

Awesome!!!

Many thanks!

Kai