Re: Age Field - Qlik Community

Report Inappropriate Content · ‎2013-03-29

Hi.

I have to field, 1. Employee Number and 2. Date of Birth. I need third field of age of each employee from today.

Calculation = Today - Employee (Date of birth). I am trying but it not comming correct.

Please find the attached qvw for data reference.

Regards,

Balachandra

alexandros17 · ‎2013-03-29

There exists a function AGE .... in date and time functions ...

kaushiknsolanki · ‎2013-03-29

Hi,

Have a look at the attachement.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Report Inappropriate Content · ‎2013-03-29

Try below.

age(Today(),Date(Date#(Field,'YYYYMM')))

Report Inappropriate Content · ‎2013-03-29

thanks for reply, how we can do the same in edit script.

regards,

Balachandra