Welcome!

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

Hide Intro Register
Q&A
1
2
Carlos Nogueira
Ligar 03/10/19, 14:04

Hi,

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
ativo 03/10/19, 14:51
1
Álvaro Damas
Ligar 03/10/19, 14:41

You can try this in the arithmetic field: 

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

  • Flag

Thanks, best regards.

Vítor Pinto
ativo 03/10/19, 14:51
Ask a Question

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)

Stats

Asked: 03/10/19, 11:12
Seen: 1704 times
Last updated: 03/10/19, 14:51