This community is for professionals and enthusiasts of the Genio platform.
Share your questions and challenges, and help your partners!


Carlos Nogueira
On 10/3/19, 2:04 PM


You can use a Genio formula to fill it. There are many methods/formulas to achieve the Age of a person, i'd recommend checking which formula is being run on other projects and also this one that i've found interesting:

"If you \convert the date using the 112 style (yyyymmdd) to a number you can use a calculation like this...
(yyyyMMdd - yyyyMMdd) / 10000 = difference in full years" - stackoverflow

Hope this helps, 

  • Flag

Thank you. Best regards

Vítor Pinto
on 10/3/19, 2:51 PM

Álvaro Damas
On 10/3/19, 2:41 PM

You can try this in the arithmetic field:

    iif( Month(Hoje) < Month([PESS1->DTNASCIM]) 
      || Month(Hoje) == Month([PESS1->DTNASCIM])
      && Day(Hoje) < Day([PESS1->DTNASCIM]),
          Year(Hoje)-Year([PESS1->DTNASCIM]) ))

  • Flag

Thanks, best regards.

Vítor Pinto
on 10/3/19, 2:51 PM

Keep Informed

About the Community

This platform is for beginners and experts willing to share their Genio knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers. Read Guidelines

Question tools

10 follower(s)


Asked: 10/3/19, 11:12 AM
Seen: 1442 times
Last updated: 10/3/19, 2:51 PM