Forum Discussion

LauraDiak's avatar
LauraDiak
Qrew Trainee
5 years ago

Calculate Years of Employee between a date/time field and today

I am trying to develop a field that automatically calculates the years of employment (including months & days) using a date/time field (Date of Hire) and whatever day it is currently.   Thank you i...
Formulas and functions
BlakeHarrison's avatar
BlakeHarrison
Qrew Captain
5 years ago
Unfortunately, there isn't a numeric field type that would produce Years, Months, and Days. You would probably need to either do 3 individual numeric formulas OR a single Text formula.


------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
This formula will do years and months. But I or someone would need to get inspired to get the days working too.

var date MyDate = [My date];
var text Years = ToText(

Year(Today())-Year($MyDate)
-
If(
Month(Today())<Month($MyDate)
or
(Month(Today())=Month($MyDate) and Day(Today())<Day($MyDate)),1,0));

var text Months =  If(
Month(Today()) > Month($MyDate), ToText(Month(Today()) - Month($mydate)),
Month(Today()) = Month($MyDate) and Day(Today()) > Day($Mydate), ToText(Month(Today()) - Month($mydate)),
Month(Today()) = Month($MyDate) and Day(Today()) < Day($Mydate), "11",

ToText(12-(Month($mydate) - Month(Today()))));

var text RawResult=
$Years & "yr" & If ($years <> "1","s") & " " &   $Months & "mth" & If($Months<>"1","s");

If($years<>"" and $Months<>"", $RawResult)

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • LauraDiak's avatar
    LauraDiak
    Qrew Trainee
    5 years ago
    Thank you.

    ------------------------------
    Laura Diak
    ------------------------------