Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I have employee Joining date field and current date(Period) field i want set analysis for number of total from employees joining date to current date(Period).
Thanks in advance.
Hi,
year(today())-year(joining date)
Hi,
as Manish suggested Age() gives you desired result.
then write
Year(Today())-Year(Date(Date#(JoiningDate),'DD/MM/YYYY'),'DD/MM/YYYY')
Regards
Hi Max i used this expression but it not working any other solution.
Can you post app which you tried
Hi
Ajay has given the correct solution.
year(today())-year(joining date)
Please find attachment.
Hi Ajay,
I got yearwise count ok,but i also want month,day wise calculation.
that means how many years,months and days?
Try below expression ....
=Age(Today(),[Joining date]) &' Years '&(If(Day(Today()) >= Day([Joining date]), MOD((Year([Joining date])*12+Month(Today()))-(Year([Joining date])*12+Month([Joining date])),12),If(MOD((Year([Joining date])*12+Month(Today()))-(Year([Joining date])*12+Month([Joining date])),12) = 0, 11 , MOD((Year([Joining date])*12+Month(Today()))-(Year([Joining date])*12+Month([Joining date])),12)-1)) )&' Months '&(if(Day(Today()) >= Day([Joining date]), Day(Today())- Day([Joining date]), Today() - AddMonths([Joining date],12*AgeYears + If(MOD((Year([Joining date])*12+Month(Today()))-(Year([Joining date])*12+Month([Joining date])),12) = 0 , 11, MOD((Year([Joining date])*12+Month(Today()))-(Year([Joining date])*12+Month([Joining date])),12)-1))))&' Days'
Hi,
Manish expression working properly and i tested its working.
=Age(Today(),[Joining date]) &' Years '&(If(Day(Today()) >= Day([Joining date]), MOD((Year([Joining date])*12+Month(Today()))-(Year([Joining date])*12+Month([Joining date])),12),If(MOD((Year([Joining date])*12+Month(Today()))-(Year([Joining date])*12+Month([Joining date])),12) = 0, 11 , MOD((Year([Joining date])*12+Month(Today()))-(Year([Joining date])*12+Month([Joining date])),12)-1)) )&' Months '&(if(Day(Today()) >= Day([Joining date]), Day(Today())- Day([Joining date]), Today() - AddMonths([Joining date],12*AgeYears + If(MOD((Year([Joining date])*12+Month(Today()))-(Year([Joining date])*12+Month([Joining date])),12) = 0 , 11, MOD((Year([Joining date])*12+Month(Today()))-(Year([Joining date])*12+Month([Joining date])),12)-1))))&' Days'
Thanks Manish its very helpfull to me also.
Please find attachment.