Calculating Employee Tenure
I have a report that displays each company employee and their tenure based on a hire date. I'd like to amend my formula to show the tenure calculated as of Dec 31st of the prior year versus it being c...
Forum Discussion
try this
var date LastDayOfPreviousYear = AdjustYear(LastDayOfYear(Today()),-1);
var number Years = Floor(ToDays($LastDayOfPreviousYear - [Original Date of Assignment])/365);
var number Remainder =Rem(ToDays($LastDayOfPreviousYear - [Original Date of Assignment]),365);
var number Months = Floor($Remainder/30.44);
var number CalcDays = Ceil(Rem($Remainder,30.44));
If([Active],
ToText($Years) & " Years" & " " & $Months & " Months" & " " & $CalcDays & " Days",
If([Role] = "Private Market Agent", "PMA", ""))
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
var date LastDayOfPreviousYear = AdjustYear(LastDayOfYear(Today()),-1);
var number Years = Floor(ToDays($LastDayOfPreviousYear - [Original Date of Assignment])/365);
var number Remainder =Rem(ToDays($LastDayOfPreviousYear - [Original Date of Assignment]),365);
var number Months = Floor($Remainder/30.44);
var number CalcDays = Ceil(Rem($Remainder,30.44));
If([Active],
ToText($Years) & " Years" & " " & $Months & " Months" & " " & $CalcDays & " Days",
If([Role] = "Private Market Agent", "PMA", ""))
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Works like a charm :)
Much appreciated Mark!
------------------------------
Todd Molino
------------------------------
Much appreciated Mark!
------------------------------
Todd Molino
------------------------------
