topic Re: Calculating Age in QlikView

Calculating Age

Thu, 28 Mar 2013 14:07:42 GMT

Hi:

I need to calculate the age based on the DOB (format: YYYY-MM-DD) that I pull out from my DB. FieldName "MBR_DOB". Any ideas will be greatly appreciate.

Thanks

Re: Calculating Age

alexandros17 — Thu, 28 Mar 2013 14:09:40 GMT

There is a date and time funcition AGE

Re: Calculating Age

Thu, 28 Mar 2013 14:11:33 GMT

Hi,

well you can try an expression like that:

Year(Today()) - Num(Left(MBR_DOB,4))

Hope it helps

regards

Giampiero

Re: Calculating Age

Thu, 28 Mar 2013 14:23:31 GMT

Thanks Giampiero:

Work perfectly. Thanks a lot.

Best Regards

CyberDan

Re: Calculating Age

Thu, 28 Mar 2013 14:34:36 GMT

Hi,

Glad to helped you.

Honestly, I think Alexandros solution is better than mine.

Try this way:

Age(Today(),MBR_DOB)

It should work.

Best regards

Giampiero

Re: Calculating Age

Thu, 28 Mar 2013 16:27:13 GMT

Both options work fine. Thanks Alexandros for your help

Thanks for your time.

CyberDan