Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

calculate years of completed service

I am trying to get years of service for employees - I have got the HireDate field - which function should  I sue to calculate years of completed service?

TIA

1 Solution

Accepted Solutions
antoniotiman
Honored Contributor III

Re: calculate years of completed service

Hi Soumya,

maybe

=Date(Today()-Date(HireDate) ,'YY-MM')

e.g.

=Date(Today()-Date('01/01/2012') ,'YY-MM')

Regards,

Antonio

2 Replies
antoniotiman
Honored Contributor III

Re: calculate years of completed service

Hi Soumya,

maybe

=Date(Today()-Date(HireDate) ,'YY-MM')

e.g.

=Date(Today()-Date('01/01/2012') ,'YY-MM')

Regards,

Antonio

Not applicable

Re: calculate years of completed service

Hi @Antonio

Thank you - I took inspiration from the formula you provided and used the following:

Year(Today())- year([Hire Date])

It is working