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
MarkShnier__You
Qrew Legend
Qrew Legendtry 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)
[email protected]
------------------------------
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)
[email protected]
------------------------------
Works like a charm :)
Much appreciated Mark!
------------------------------
Todd Molino
------------------------------
Much appreciated Mark!
------------------------------
Todd Molino
------------------------------