Want to find out experience based on hire date

[Rajveer]

Hi Team,

Glad to hear that such great community, Just wanted to find out the experience based on hire date 
I have tried in Qlik but not working this =Num( date#(year(today()) -Year([Hire Date]))) expression.
And totally new in this platform. can someone please help.

Thanks,
Rajveer

[zhaofeng]

If your Hire Date is a standard date format,such as YYYY-MM-DD,you can use the expression below

num(today())-num([Hire Date])

You will directly get the day difference between two dates.

[Rajveer]

Thanks a lot, it is working in Days, but I have converted into year year(num(today()))-year(num([Hire Date],'Year'))
in this expression but still not working in year wise. And Some of the date field not getting blank.