topic Any easy formula/expression for computing age in years with dateofbirth field? in QlikView

Any easy formula/expression for computing age in years with dateofbirth field?

stevelord — Mon, 02 Mar 2015 19:04:26 GMT

Hi, Is there a simple formula/expression for computing age in years if you have a dateofbirth field provided?

I gave a colleague a simple dual if statement about if dateofbirth>=, < 365.25*18 days to make a yes/no field about person being 18, but it might miss by a fraction of a day or something and wondering if we have something silly like an aghe(dateofbirth) function laying around. (Note the sentence was not the actual dual statement, I just typed it out phoenetically here. )

Re: Any easy formula/expression for computing age in years with dateofbirth field?

eespiritu — Mon, 02 Mar 2015 19:17:19 GMT

Try this:

=year(now()) - year(dateofbirth)

Enrique

Re: Any easy formula/expression for computing age in years with dateofbirth field?

martinpohl — Mon, 02 Mar 2015 19:35:38 GMT

How about the age function?

it calculates the age:

age(today(),date) as age

Regards

Re: Any easy formula/expression for computing age in years with dateofbirth field?

stevelord — Mon, 02 Mar 2015 23:30:01 GMT

Thanks, next time I'll just try typing the obvious in script and see if autofill suggests the function for me. I told my colleague before posting here, 'I'll check on qlikcommunity in case there's something silly easy like age()'.. Completely unexpected.

I tested in a textbox for myself, with today's date and a birthday earlier and later than today, and it worked fine.