topic Years of Service date expression in QlikView https://community.qlik.com/t5/QlikView/Years-of-Service-date-expression/m-p/483921#M180809 <HTML><HEAD></HEAD><BODY><P>I have the start date of a person (in date format from an Excel load), now i would like to calculate (with an expression) their years of service with an end date of today?</P></BODY></HTML> Sat, 14 Dec 2013 06:50:26 GMT 2013-12-14T06:50:26Z Years of Service date expression https://community.qlik.com/t5/QlikView/Years-of-Service-date-expression/m-p/483921#M180809 <HTML><HEAD></HEAD><BODY><P>I have the start date of a person (in date format from an Excel load), now i would like to calculate (with an expression) their years of service with an end date of today?</P></BODY></HTML> Sat, 14 Dec 2013 06:50:26 GMT https://community.qlik.com/t5/QlikView/Years-of-Service-date-expression/m-p/483921#M180809 2013-12-14T06:50:26Z Re: Years of Service date expression https://community.qlik.com/t5/QlikView/Years-of-Service-date-expression/m-p/483922#M180810 <HTML><HEAD></HEAD><BODY><P>try this</P><P>Age(Now(2), [start date from excel])</P><P></P><P>Now parameter</P><P>0 Time at previously finished reload (not currently ongoing reload)</P><P>1 Time at function call</P><P>2 Time when the document was opened&nbsp;&nbsp; </P></BODY></HTML> Sat, 14 Dec 2013 07:49:58 GMT https://community.qlik.com/t5/QlikView/Years-of-Service-date-expression/m-p/483922#M180810 maxgro 2013-12-14T07:49:58Z