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.
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'
Not Clear.. You want to find the total number of employees or total days employee joined?
Can you explain bit more?
Hi Manish,
i am giving example
suppose my employee joinning date is (16/12/2006) and my current date is my today date(11/09/2014) so i want total no of years and day expecated ans is(8) years.
so how i Count this?
Hi,
Try like
Count({calenderDateField={">=$(=date(max(EmployeeJoiningDate)))<=Date(Today())"}}Employee)
Regards,
Hi,
try with interval()
like
interval(today()-employeeJoiningDate,'D')
Regards,
To find the number of employees that have joined from a particular date you could use.
count({<Joined Date>={<Your date>}>} Employee)
Age(Today(),[Joining Date])
Hi,
count({<Joined Date={"<=$(=max(period))"}>} Employee)
Regards,
Ajay
hi every one,
Once again i repeat my qustion with example-:
I have one employee id=100 his joining date is (14/12/2006) and want set analysis how many years he working in organization? till today date(11/09/2014)