topic Re: Age Field in QlikView https://community.qlik.com/t5/QlikView/Age-Field/m-p/406949#M151393 <HTML><HEAD></HEAD><BODY><P>There exists a function AGE .... in date and time functions ...</P></BODY></HTML> Fri, 29 Mar 2013 12:25:08 GMT alexandros17 2013-03-29T12:25:08Z Age Field https://community.qlik.com/t5/QlikView/Age-Field/m-p/406948#M151392 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>I have to field, 1. Employee Number and 2. Date of Birth. I need third field of age of each employee from today.</P><P></P><P>Calculation = Today - Employee (Date of birth). I am trying but it not comming correct.</P><P></P><P>Please find the attached qvw for data reference.</P><P></P><P>Regards,</P><P>Balachandra</P></BODY></HTML> Fri, 29 Mar 2013 12:14:53 GMT https://community.qlik.com/t5/QlikView/Age-Field/m-p/406948#M151392 2013-03-29T12:14:53Z Re: Age Field https://community.qlik.com/t5/QlikView/Age-Field/m-p/406949#M151393 <HTML><HEAD></HEAD><BODY><P>There exists a function AGE .... in date and time functions ...</P></BODY></HTML> Fri, 29 Mar 2013 12:25:08 GMT https://community.qlik.com/t5/QlikView/Age-Field/m-p/406949#M151393 alexandros17 2013-03-29T12:25:08Z Re: Age Field https://community.qlik.com/t5/QlikView/Age-Field/m-p/406950#M151394 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Have a look at the attachement. </P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Fri, 29 Mar 2013 12:28:08 GMT https://community.qlik.com/t5/QlikView/Age-Field/m-p/406950#M151394 kaushiknsolanki 2013-03-29T12:28:08Z Re: Age Field https://community.qlik.com/t5/QlikView/Age-Field/m-p/406951#M151395 <HTML><HEAD></HEAD><BODY><P>Try below.</P><P></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;"> </SPAN><SPAN style="background-color: #ffffff; font-size: 12px; font-family: Arial; color: #636363;">age(Today(),Date(Date#(Field,'YYYYMM')))</SPAN></P></BODY></HTML> Fri, 29 Mar 2013 12:36:54 GMT https://community.qlik.com/t5/QlikView/Age-Field/m-p/406951#M151395 2013-03-29T12:36:54Z Re: Age Field https://community.qlik.com/t5/QlikView/Age-Field/m-p/406952#M151396 <HTML><HEAD></HEAD><BODY><P>thanks for reply, how we can do the same in edit script.</P><P></P><P>regards,</P><P></P><P>Balachandra</P></BODY></HTML> Fri, 29 Mar 2013 12:40:53 GMT https://community.qlik.com/t5/QlikView/Age-Field/m-p/406952#M151396 2013-03-29T12:40:53Z