I have a column "Joining date" and we have to calculate employee tenure as of the date we run (currentdate).
and we have to display it in format
eg: if employee has joined on 5 jan 2015 so his tenure should display 1year 4month 2days(example)
I have calculated the daysbetween those dates and got some number
any idea on how to display it in the format?