Need to get the year - month

[j_qlikview]

Hi,

We have the customesrs who are about to finish their 5 years of service with our client ,so i have to get the list of people who would be reach their service to 5 years by next month (i mean to say for 5 years it will be 60 months so i need to shortlist the people who are in their 59month of service) how can i achieve it in i did tried to use this following expression "age(AddMonths(today(),1), ServiceYears) as NextMonthemp.

Please need help on this..

Thanks in advance

Jahnavi...

[prma7799]

Like this?

Age:

LOAD

    Customer,

    DateofJoin ,

    Year(DateofJoin) as Years ,

    age( Today () , DateofJoin ) as ServiceYears

FROM

Age.xlsx

(ooxml, embedded labels, table is Sheet1);